PivotTable source error, but data is refreshing

[Guest82943]

Hoping someone can help me out. I have a workbook with about a dozen tabs, 4-5 of which are pivottables, 4 are charts, and the rest data. All of the cells throughout all the tabs are pretty intricately linked, but all within the same workbook. All of the PivotTables pull data from the same tab.

Every time I hit refresh all I get an error message that says 'Cannot open PivotTable source file" with a link to a temp file (the original workbook was downloaded off an email, than saved to respective hard drive).

But the data is refreshing just fine. I thought perhaps the links didn't update when the file was moved from a temporary location to being saved on a hard drive, but I triple checked all of the PivotTable source files - they are all pulling data from a tab within the same workbook. Also, no cells anywhere are showing N/A, REF, or any other type of error. The data refreshes fine, I just want to get rid of this error message that keeps popping up.

I'm out of ideas. Anybody ever had this problem?

[RobertMika]

have you tried.
Data-Edit Links - Break Links..

[:) Sixthsense :)]

Place the cursor inside the Pivot Table>>Press Alt+J+T+I+D

Or

Pivot Table Tools>>Options>>Change DataSource

Check the Source in the popup window

[Guest82943]

The Edit Links option is greyed out on every single tab in the worksheet.

I have also double and triple checked the data source on each pivot table. They all pull from a tab in the workbook - plus they're all showing data, so if something was linked to an external source that couldn't be found, wouldn't it either be showing all blank values or error messages of some sort?

[:) Sixthsense :)]

Use Pivot Play or Pivot Play Plus which you can get from web easily....

It's very handy for Pivot Table

[Guest82943]

Found the problem (EUREKA!!)

There were hidden sheets in the workbook, which had pivot tables linking to external sources. I didn't create the file so wasn't aware there were hidden sheets. Solves this, and thank God, it was driving me crazy!

[:) Sixthsense :)]

Glad you fixed it, and thanks for the feedback