שבת 24 דצמבר 2011 09:00
When I try to export to excel in report viewer i got "The file you are trying to open 'Test.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?
יום שלישי 07 פברואר 2012 17:54I 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?
יום חמישי 23 פברואר 2012 09:16
I met the same issue above.Only users in Local Administrators group can export Excel file. Can anybody help ?
- נערך על-ידי Rottess יום חמישי 23 פברואר 2012 09:16
יום חמישי 23 פברואר 2012 21:43
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.
יום שישי 24 פברואר 2012 03:23I have the same issue. Any help must be appreciated.
יום רביעי 29 פברואר 2012 07:36
I fixed the issue by doing the following steps:
- Login to your web front end server
- Identify your web site pool account
- Open CMD
- Run this command "runas /u:<Your Pool Account> /profile cmd"
- A new CMD will be opened. Paste this command to this CMD: "echo %userprofile%"
- Remember this temp folder
- Create a folder in this location "%userprofile%\AppData\Local\Temp" and assign Modify Permission to Everyone
Hope this will help you resolve the issue :)
יום חמישי 01 מרץ 2012 19:11
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.