LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Bug with pivot tables corrupting in Excel 2007

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?
--
Mike
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Excel Pivot Tables - turn off subtotals DingBat Excel Discussion (Misc queries) 3 December 23rd 06 03:55 PM
Excel 2007 charting errors with pivot tables Lerxst Charts and Charting in Excel 0 December 6th 06 09:02 PM
Excel 2007 Error Reopening Pivot tables Mike L Setting up and Configuration of Excel 6 November 24th 06 09:53 PM
Pivot Tables keep corrupting -- Office 12 beta mpatten Excel Discussion (Misc queries) 1 May 30th 06 08:59 PM
VB Corrupting Pivot Tables RestlessAde Excel Discussion (Misc queries) 3 August 6th 05 01:52 PM


All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"