![]() Excel repaired the file, and re-opened it, with a “Repaired” message that I didn’t read (oops!)Īpparently the Excel table had some corruption, so Excel removed it, and I didn’t notice.Then I remembered – Excel had crashed the day before, while I worked on that file.I work alone, so there were no co-workers to blame.Mysteriously, the table had converted back to a simple list, with all of the table structure removed. Next, I checked the data sheet, and there was no nicely formatted Excel table. Usually, Excel finds the source data range, and highlights it with “marching ants”. It was strange though – the pivot table was still showing in the background. As expected, it showed a named Excel table, Table1, as the source.I checked the data source for one of the pivot tables.Both pivot tables were based on the same data source.If I tried to refresh either pivot table, the error message appeared.What else could have a reference problem? Well, there were two pivot tables in the workbook, so I checked them next. That chart was not the problem! Check the Pivot Tables Unfortunately, a few seconds later, the error message appeared again. That chart must be the problem! So, I clicked OK, then deleted the chart, and figured I’d rebuild it later. When the message appeared, there was a greyed-out chart behind it. I’ve seen that error with Excel charts before, but this turned out to be a pivot table problem. Immediately, an error message appeared, “Reference isn’t valid”. Tuesday morning, I opened an Excel file that I’d been working on the day before. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |