Pivot Table Cache

**pivot** · 06-22-2009, 11:37 AM

Hello,

Let's say I have a pivot table made from data in another workbook. The other workbook is then deleted.

Is there anyway to get the original data back?

My particular file is about 10 MB, but if I "save as" it's only 1 MB. Plus, the pivot table "works," so I'm pretty sure Excel still has my data cached somewhere. How can I access it?

I'm decent with VBA, so I'm open to any solution at all.

Thanks for any help!

**NBVC** · 06-22-2009, 03:35 PM

Not sure of this is of any assistance... but worth a look...

http://www.contextures.com/xlPivot11.html

**pivot** · 06-22-2009, 05:10 PM

Originally Posted by NBVC

Not sure of this is of any assistance... but worth a look...

http://www.contextures.com/xlPivot11.html

Thanks, but I did happen to look at that very link before I posted.

It's helpful, but I don't think it will let me get at the actual data itself.

**pivot** · 06-23-2009, 11:17 AM

No one knows how to do this? Or if it's possible?

**pivot** · 07-08-2009, 11:13 AM

So... I found an answer elsewhere.

I forgot that when you double click on a point of data, Excel will create a new sheet and place the complete, relevant row of data.

Well, if you make sure the pivot table is displaying all fields and has row and column totals, just go to the very bottom right where the totals fields intersect and double click it. You'll get a new sheet with all the original data.

Case Closed

**NBVC** · 07-08-2009, 11:30 AM

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save