12 September, 2013

An Excel workbook that contains a PowerPivot table is corrupted after you upload the Excel workbook to a SharePoint PowerPivot gallery


Problem:
One of our clients reported when he tried to open Excel workbook which contains Pivot table from the SharePoint Pivot Gallery, after doing the refresh, the Excel workbook doesn’t open or opens in the repair mode.


Background: Office 2010, Excel 2010. Windows 7 64-bit.


Troubleshooting:
1)   Checked if multiple versions of office installed.
2)   Downloaded the local copy of the file and it was opening fine.
3)   Checked the content of the Excel file that does contain the pivot tables and using the external connection in the source file was fine.
4)   Tried to use the different connection string in the Excel, i.e. fetching data from any other external source.
5)   Local copy of the file was working fine, whereas when publishing to SharePoint it breaks.

Resolution:
This was a prolonging issue and MS has confirmed that this is not a SharePoint issue and has to be the SQL 2008 issue, which got fixed in the Cumulative update 2 for SQL Server http://support.microsoft.com/kb/2072493

You can also get a hot fix which is supported by KB- http://support.microsoft.com/kb/2028769

If you face any difficulties or have any further queries, please flag them, I would be happy to assist you with them.

Applies to:
Microsoft SQL Server 2008 R2 Enterprise
Microsoft SharePoint Server 2010
Microsoft Excel 2010

No comments:

Post a Comment

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge