Export to Excel in Report Viewer Issue

Question

Hi,

When I try to export  to excel in report viewer i got "The file you are trying to open 'Test[1].xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do  you want to open the file now?" warning and if i click Yes, excel page will be  blank.

If I am logged in my sharepoint intranet portal with Admin account, I can export into excel.but in normal user case its not working.PDF is working in both users.

 

Let me know any solution?

---

Jamshid

Answer 1

I have the exact same issue. I have tried a number of different suggestions on other forums, but I cannot get this to work. I was told to add full permissions to the Temp dir to all domain users. I tried that as well as adding ISS users, etc. Anyone else have any luck?

Answer 2

I met the same issue above.Only users in Local Administrators group can export Excel file. Can anybody help ?

Answer 3

I have the same issue.  On the spadmin account can get the export to work.  All other users get a blank xls or doc file.  I've tried changing permissions on the local temp directory, but nothing has worked. 

Answer 4

I have the same issue. Any help must be appreciated.

Answer 5

I fixed the issue by doing the following steps:

1. Login to your web front end server
2. Identify your web site pool account
3. Open CMD
4. Run this command "runas /u:<Your Pool Account> /profile cmd"
5. A new CMD will be opened. Paste this command to this CMD: "echo %userprofile%"
6. Remember this temp folder
7. Create a folder in this location "%userprofile%\AppData\Local\Temp" and assign Modify Permission to Everyone

Hope this will help you resolve the issue :)

Answer 6

Here is the solution that I used. 

The web server was making a new user for the process (temp.domainName.001) and was using the temp folder inside this user to process the excel or word doc.  I added Authenticated Users to the temp directory with Full permissions and voila, problem solved.

---

vincent gould