Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unexpected error 1004 when using workbooks.open | Excel Programming | |||
Workbooks.Add and SaveAs don't occur | Excel Programming | |||
SaveAs and Hidden Workbooks | Excel Programming | |||
SaveAs without prompt | Excel Programming | |||
Shared workbooks, advanced filters, and refreshing pivot tables | Excel Programming |