Bug with pivot tables corrupting in Excel 2007

M

Mike Croom

I summarise our time recording data (11000 rows, 1.2MB) with a simple pivot
table. On 3 separate occasions with 3 different cuts of the data it has
corrupted.

Symptoms:
All OK when you create the pivot table and save as .xlsx. But when you next
open the file you get a message: "Excel found unreadable content". Recovery
removes the pivot table!
Looks like http://support.microsoft.com/kb/929766/en-us but I can't see
where to remove references to Current Time Member as it advises. I am not
connected to SSAS though the data came from SRS
I do add Calculated Fields to the Pivot table - and would like to keep doing
so

Is this the known bug or a new one?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 vlookup with Pivot table 0
Excel 2007 pivot table using analysis services cube as data source 0
pivot table 0
Excel 2007 pivot table: select multiple data easier 0
Excel 2007 pivot table source table 1
grouping multiple tables Excel 2007 3
Pivot Table - 2
Excel 2007 Pivot Table Changes the Source Data Range 1

Top