A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Prevent dialogue: "save changes"?



 
 
Thread Tools Display Modes
  #1  
Old May 14th, 2010, 01:57 AM posted to microsoft.public.excel.newusers
[email protected]
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

  #2  
Old May 14th, 2010, 03:51 AM posted to microsoft.public.excel.newusers
ozgrid.com
external usenet poster
 
Posts: 328
Default Prevent dialogue: "save changes"?

You probably have Volatile formulas within. E.g TODAY,NOW etc These formula
recalculate every time you open the file or do most things in Excel.


--
Regards
Dave Hawley
www.ozgrid.com


wrote in message
...
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


  #3  
Old May 14th, 2010, 05:54 PM posted to microsoft.public.excel.newusers
[email protected]
external usenet poster
 
Posts: 3
Default Prevent dialogue: "save changes"?

Thank you
Is there a way to ony make this calculate when the sheet (where I use
now() ) is opened?

On Fri, 14 May 2010 10:51:05 +0800, "ozgrid.com"
wrote:

You probably have Volatile formulas within. E.g TODAY,NOW etc These formula
recalculate every time you open the file or do most things in Excel.

  #4  
Old May 14th, 2010, 09:34 PM posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Prevent dialogue: "save changes"?

Set Calculation Options to Manual and uncheck "recalculate before save"

Add this event code to the worksheet in question.

Private Sub Worksheet_Activate()
Application.Calculate
End Sub

Only when you select that sheet will you calculate.

Note: if you open this workbook after a workbook with calculation set at
auto, this workbook will also be changed to auto-calc.

i.e. First workbook opened determines the calculation mode for subsequent
workbooks.

You have to be careful with this...................


Gord Dibben MS Excel MVP

On Fri, 14 May 2010 18:54:21 +0200, wrote:

Thank you
Is there a way to ony make this calculate when the sheet (where I use
now() ) is opened?

On Fri, 14 May 2010 10:51:05 +0800, "ozgrid.com"
wrote:

You probably have Volatile formulas within. E.g TODAY,NOW etc These formula
recalculate every time you open the file or do most things in Excel.


  #5  
Old May 16th, 2010, 05:34 PM posted to microsoft.public.excel.newusers
[email protected]
external usenet poster
 
Posts: 3
Default Prevent dialogue: "save changes"?

Thank you very much!!


On Fri, 14 May 2010 13:34:59 -0700, Gord Dibben gorddibbATshawDOTca
wrote:

Set Calculation Options to Manual and uncheck "recalculate before save"

Add this event code to the worksheet in question.

Private Sub Worksheet_Activate()
Application.Calculate
End Sub

Only when you select that sheet will you calculate.

Note: if you open this workbook after a workbook with calculation set at
auto, this workbook will also be changed to auto-calc.

i.e. First workbook opened determines the calculation mode for subsequent
workbooks.

You have to be careful with this...................


Gord Dibben MS Excel MVP

On Fri, 14 May 2010 18:54:21 +0200, wrote:

Thank you
Is there a way to ony make this calculate when the sheet (where I use
now() ) is opened?

On Fri, 14 May 2010 10:51:05 +0800, "ozgrid.com"
wrote:

You probably have Volatile formulas within. E.g TODAY,NOW etc These formula
recalculate every time you open the file or do most things in Excel.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:34 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.