![]() |
Unexpected SaveAs prompt for workbooks with pivot tables
Hello,
I have been noticing since I got migrated to Office2000 that my excel workbooks with pivot tables frequenty (and unexplainably) will prompt me to "save changes" when I have just opened them to look at data and try to close the file again. NOTE: The workbooks I'm referring to do NOT have any programmed macros or VBA code. Here are my observations: - workbooks with embedded pivot tables are more likely to exhibit the "phantom save as" behavior that workbooks without pivot tables. - the behavior usually occurs when you open the workbook and activate any cell within its pivot table. It appears that excel thinks you clicked "refresh table". - by answering "yes" to the "save as" prompt, the behavior (at least temporarily) goes away. (next time you open it, and close without changing anything, you don't get asked to "save as") Anybody else notice this happening? |
All times are GMT +1. The time now is 05:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com