Cannot open PivotTable source file

When I try to Refresh All my PivotTable gives me the error "Cannot open PivotTable source file". This source file is a report in a book that is several years old. I did not and have not asked this PivotTable to be connected to this report. I have ran a search and find on the entire workbook for the wrong source file. Nothing is found. This error is limiting the ability to change Pivot Styles. How to I fix this?

this might help
http://support.microsoft.com/kb/831929

I don't quite understand what you mean. Is it possible that you post a sample of the file containing the malfunctioning pivot table?

This doesn't work for me because it is not hosted on a web server.
This is locally hosted.

Any more suggestions?

Originally Posted by PeteABC123

this might help
http://support.microsoft.com/kb/831929

File is to large to post with sensitive data.

Originally Posted by ExcelClout

I don't quite understand what you mean. Is it possible that you post a sample of the file containing the malfunctioning pivot table?

This was incredibly helpful! Thank you so much.

Originally Posted by romperstomper

Try running this:

Please Login or Register  to view this content.

which will create a sheet showing the source for each pivot table, as well as the table's location.