ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unexpected SaveAs prompt for workbooks with pivot tables (https://www.excelbanter.com/excel-programming/342247-unexpected-saveas-prompt-workbooks-pivot-tables.html)

KentL

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