Hi,

I have a sales data file that I update monthly. The data is displayed in pivot tables and regular charts. This month when I paste data into one of the sheets everything seems fine, I can update the pivot tables without a problem. But when I restart the file I get the error message "The pivot table report is invalid. Try refreshing the data (On the Options tab click refresh)" which doesn't work. Sometimes Excel also needs to repair the file, referring to a pivot table called 16, but I don't have a number 16. Regardless, repairing the file doesn't work.

I've tried different kinds of data, formatting etc. and it doesn't seem to be any of the data in particular. It also seems very inconsistent as it sometimes seems to work pasting parts of the data (though next time the same data won't work), or restarting the file once works but not twice.

Would greatly appreciate help on this as I'm not particularly keen on rebuilding the whole again...

I'm using Excel 2010, the file is 3MB and the sheet that seems to be causing problems has 2000 rows in it.

Thanks!