Does anyone have a resource that gives possible reasons for this error message in Excel. I've googled around and looks like lots of people encounter the message but no one replies with concrete suggestions for resolving.
The actual source of data is an Excel list and is only 1000 rows long and a few users use this pivot table and refresh successfully only a couple encounter this error message when refreshing the exact same spreadsheet. They do not refresh at same time.
How many columns? Do some of the users who are refreshing have less memory in their systems?
Hi
I have encountered this problem a few times now and have tried every possible solution. I have also googled to find an answer and no one seems to have one. What I believe is that the file has become corrupt and you need to start a new spreadsheet, there is no way to fix this problem. I now just have a template spreadsheet with pivot tables ready and when I encounter this message simply copy all data from the corrupt file and paste into the template, then refresh my pivot tables and it is all fine. I don't beleive it has anything to do with memory or capability of excel, as I use a new pivot table for each month of data entry and it has happened with small amounts of data and large also.