Excel 2007 Services

I have a test environment with Office 2007, including Sharepoint and excel services. I was able to publish pivot table reports to a report library and then include them in dashboards and analyse in my web browser. Now al of a sudden, after publishing an excel report to excel services and when I try to open it in my web browser, I get the following error message: "The file you selected cannot be opened because it is corrupt, protected by Information Rights Management, or in a file format not supported by Excel Services. Excel 2007 may be able to open this file". Indeed the full client is able to open the file.

What strikes me is that editing the excel reports which worked fine in the past and republishing them, causes no problems. However after adding a pivot table, the same problem occurs.

Any idea?

Thanks in advance

Joos

Thank you for your post - Our group is having the same issue - seeing that your post was placed 6 weeks ago - was there a solution or fix that made the function work for your group?

Thank you,

proliant5000@.hotmail.com

|||

Moving to RS forum

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I did fix it but I do not know how...I guess a reinstall fixed the problem.

But there is another problem. I have to store username and password in the connection. If not, I get an error message in sharepoint.

I would like normal windows authentication to use the roles defined in AS.