Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unexpected error 1004 when using workbooks.open AHD Excel Programming 5 June 6th 05 11:19 PM
Workbooks.Add and SaveAs don't occur Gareth Roberts Excel Programming 0 March 15th 05 02:04 PM
SaveAs and Hidden Workbooks wtpcomplab Excel Programming 1 December 11th 04 01:27 AM
SaveAs without prompt Steven K0 Excel Programming 2 September 17th 04 02:34 AM
Shared workbooks, advanced filters, and refreshing pivot tables Lara[_2_] Excel Programming 0 April 15th 04 11:59 PM


All times are GMT +1. The time now is 04:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"