LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default Prevent dialogue: "save changes"?

I've got this workbook with several worksheets.
If I open this workbook and close it, the question if I want to save
the changes is asked every time. Even if I didn't make any changes.

I think there could be 2 reasons for this dialogue window.

1- I don't close the file with the same worksheet in the front.
If the file is opened with sheet2 in front when I open it, and look at
sheet1, and the close it. Could this be a reason that the "save
changes" question is asked?

2- In one of the sheets, I use the now() formula.
The sheet is calculated automatically. Could it be that the now()
makes the program think the sheet is changed?
I don't open the sheet where the now() function is used very often, so
if this causes the "save changes", it would be great to make the now()
function only when the sheet is viewed.

Could these be the reason for the "save changes" question even if the
sheet was only opened to view a sheet?
What can I do to prevent the question every time, even when there
weren't any changes?

Thanks in advance

 
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
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 ronhansen Excel Discussion (Misc queries) 1 November 15th 09 09:33 PM
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION yossie6 Excel Discussion (Misc queries) 1 June 16th 08 12:16 PM
"Save In" dialog (dialogue) issue Dan Levin Excel Discussion (Misc queries) 0 April 1st 08 06:20 PM
In Excel 2003 is there a way to prevent "Save As" and "Print"? lucky2000 Excel Discussion (Misc queries) 3 April 26th 07 02:49 PM
"Save" and "Save As" options greyed out - "Save as Webpage" option Bill Excel Discussion (Misc queries) 0 January 16th 07 04:47 PM


All times are GMT +1. The time now is 04:36 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"