I run a Pivot Table controlled and loaded by VBA, but when I fiddle with other code controlling the operation of the *.xls file, I often get the message 'UNABLE to read file' and then on enabling the macros the repair result 'PivotTable report idscarded due to integrity problems' Please can someone tell me what is happening or where to find out what the problem is. I have changed recently to Office XP and did not have this error before as far as I can remember.