Pivot table report invalid

N

niccideaves

Hi All

When using a report with several pivot tables, I am copying the data in by Column, Format and Value. When I run the Refresh to update all pivot tables in the report it works fine. Then I make one minor change to the text onone tab, so that it reads the same in all tabs, again copying in by value only and when I try to Refresh again I get a Run-time error '1004' and a "this pivot table report is invalid". Anyone know why this should happen?
 

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

Dealing with a Pivot Table (when I don't want to) 0
Dates In Excel 5
Excel 2013 Pivot Data Range formula reference problem 0
Doughnut Chart linked with the slicer in the pivot table 0
SUM & OFFSET & PIVOT TABLE?? 0
Multiple Pivot Tables Expand to Fit 0
Pivot Table Counting Text Issue 0
pivot tables in multiple workbooks using one datasheet? 3

Top