Access Services – Can’t Export Report Data to Excel or Word

Question

 BOTTOMLINE: Does anyone know of any fixes or workarounds to enable Access Services to export report data to Excel or Word as detailed below?

·          

PLEASE NOTE: I am talking about Access Services running under SharePoint; not client-side Access applications.

 

When a report is rendered on the web, there is an Actions button (at bottom left hand corner) which provides the options to print the report or export the report data to .pdf, Excel or Word (see first image). Printing works and exporting to .pdf  also works just fine.  However when you try to export to Excel you receive the message shown in the second image and when you click ‘Yes’ Excel opens up but there is no data.  When you try to export to Word, the application (Word) opens up but there is nothing in the file (i.e., a blank Word document).  In addition, export works fine when the user los in as administrator.

 

Based on a variety of web searches regarding this issue, it would appear that this was a known, unsolved problem way back at the end of 2010 (for example:  http://accesshosting.zendesk.com/entries/266484-exporting-report-data-to-ms-excel-or-ms-word)

 

Does anyone know how to get the exportation of report data to Excel and Word to work?

Answer 1

Hello mmtwtc,

Thank you for your question.

I am trying to involve someone familiar with this topic to further look at this issue.

---

Wayne Fan

TechNet Community Support

Answer 2

Thank you Wayne Fan.

Answer 3

Ask your administrator if Excel services have been configured on the server.

Answer 4

Yes, Excel services is configured on the server.

Answer 5

Did anyone find a solution for this?

Answer 6

Hi mmtwtc,

Can you share which browser you're currently attempting the export with?  Can you test with granting the end user "Modify" rights on %WINDIR%\Temp to see if the export is then successful to Word and/or Excel?

Thanks!

Bob

Answer 7

I'm using i.e.8.

I granted the end user "modify" on the temp directory, but the export still didn't work.

It only works when the user logs in using the admin username and pwd.

Thanks.

Answer 8

Hi mmtwtc,

Thanks for trying that for me.  I haven't found any other indication of what the problem may be, nor a valid workaround for this issue, so what I would recommend is that you open a paid support case so that the team that supports Access Services can identify what the problem is in your specific scenario.  I'm sorry that I wasn't able to identify a solution for you.

Best Regards,

Bob

Answer 9

I found this post recently, as I am having the same issue. Looks to be an issue with access to SQL:

http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/bdff4417-7d2c-4060-8baf-983510883cc0

Not sure what a good solution is though....

---

Erich O'Donnell | SharePoint Administrator