I have a workbook that when I open the file and immediately close it, I get
the 'Do you want to save' msgbox.

I insured that the auto_open was disabled. When the file is opened it seems
to have the .Saved property always set to False. I tried to hold the shift
when I open it, same behavior.

What can I check to determine why? I can't figure out what is causing this.

Thanks,
John

Could you use the Application.Displayalerts = False to ensure the msg
isnot given ?

"DocBrown" wrote in message
...
I have a workbook that when I open the file and immediately close it, I get
the 'Do you want to save' msgbox.

I insured that the auto_open was disabled. When the file is opened it
seems
to have the .Saved property always set to False. I tried to hold the shift
when I open it, same behavior.

What can I check to determine why? I can't figure out what is causing
this.

Thanks,
John

That just hides the issue. I want to know why it is occuring and fix the root
cause. What if the property that is causing .Saved to go False is something I
need to know about.

I have another template/workbook set that has very similar structure and
macros and it doesn't do this. I can't determine the difference.

John

"Corey" wrote:

Could you use the Application.Displayalerts = False to ensure the msg
isnot given ?

"DocBrown" wrote in message
...
I have a workbook that when I open the file and immediately close it, I get
the 'Do you want to save' msgbox.

I insured that the auto_open was disabled. When the file is opened it
seems
to have the .Saved property always set to False. I tried to hold the shift
when I open it, same behavior.

What can I check to determine why? I can't figure out what is causing
this.

Thanks,
John

Ok, I've done more testing...

If I do the shift-open to inhibit macros and go into VBA, The immediate
window gets:
?workbooks("CDM_Account1.xls").Saved
False

If I enable my auto_open macro and have this as the first executable liine:

Debug.Print "AutoOpen Enter: Saved=" & ThisWorkbook.Saved
displays this:
AutoOpen Enter: Saved=False

If I go to Tools-Options... Calculation and set Calculation=manual the
problem goes away. My workbook won't work as I want it if I turn that off,
though.

Any idea wWhat types of forumula will trigger this? I'll keep debugging the
forumulas....

John

"DocBrown" wrote:

I have a workbook that when I open the file and immediately close it, I get
the 'Do you want to save' msgbox.

I insured that the auto_open was disabled. When the file is opened it seems
to have the .Saved property always set to False. I tried to hold the shift
when I open it, same behavior.

What can I check to determine why? I can't figure out what is causing this.

Thanks,
John

The most likely cause is a volatile or volatile-at-open function.
See http://www.decisionmodels.com/calcsecretsi.htm

Another less likely possibility is that Excel is recalculating the workbook
at open because it was last calculated by a different version of Excel.

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"DocBrown" wrote in message
...
Ok, I've done more testing...

If I do the shift-open to inhibit macros and go into VBA, The immediate
window gets:
?workbooks("CDM_Account1.xls").Saved
False

If I enable my auto_open macro and have this as the first executable
liine:

Debug.Print "AutoOpen Enter: Saved=" & ThisWorkbook.Saved
displays this:
AutoOpen Enter: Saved=False

If I go to Tools-Options... Calculation and set Calculation=manual the
problem goes away. My workbook won't work as I want it if I turn that off,
though.

Any idea wWhat types of forumula will trigger this? I'll keep debugging
the
forumulas....

John

"DocBrown" wrote:

I have a workbook that when I open the file and immediately close it, I
get
the 'Do you want to save' msgbox.

I insured that the auto_open was disabled. When the file is opened it
seems
to have the .Saved property always set to False. I tried to hold the
shift
when I open it, same behavior.

What can I check to determine why? I can't figure out what is causing
this.

Thanks,
John

Hi Charles,

Yup, you nailed it. I have the following formulas:
=IF($J$7 <"",$J$7,NOW())

and

=OFFSET(O16,-1,0)+M16-N16

The first one just fills in a date column from a field in a header area. The
second automatically calculates a running balance when expenses are entered
in M and payments are entered in N. I did the running balance this way
because I couldn't figure out a way to make this work when the user inserts
new rows. It's not perfect because the user still needs to do a fill down to
populate the inserted rows because Excel does not propagate the formulas when
rows are inserted.

Is there another way to calulate a running balance that won't trigger the
volitile and where the user can still insert rows?

John

"Charles Williams" wrote:

The most likely cause is a volatile or volatile-at-open function.
See http://www.decisionmodels.com/calcsecretsi.htm

Another less likely possibility is that Excel is recalculating the workbook
at open because it was last calculated by a different version of Excel.

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"DocBrown" wrote in message
...
Ok, I've done more testing...

If I do the shift-open to inhibit macros and go into VBA, The immediate
window gets:
?workbooks("CDM_Account1.xls").Saved
False

If I enable my auto_open macro and have this as the first executable
liine:

Debug.Print "AutoOpen Enter: Saved=" & ThisWorkbook.Saved
displays this:
AutoOpen Enter: Saved=False

If I go to Tools-Options... Calculation and set Calculation=manual the
problem goes away. My workbook won't work as I want it if I turn that off,
though.

Any idea wWhat types of forumula will trigger this? I'll keep debugging
the
forumulas....

John

"DocBrown" wrote:

I have a workbook that when I open the file and immediately close it, I
get
the 'Do you want to save' msgbox.

I insured that the auto_open was disabled. When the file is opened it
seems
to have the .Saved property always set to False. I tried to hold the
shift
when I open it, same behavior.

What can I check to determine why? I can't figure out what is causing
this.

Thanks,
John

hi,
that occure when some changes happen before debug.print book.saved
try to check whether you have another code which change part of your book.
--
Regards,

Halim



"DocBrown" wrote:

Ok, I've done more testing...

If I do the shift-open to inhibit macros and go into VBA, The immediate
window gets:
?workbooks("CDM_Account1.xls").Saved
False

If I enable my auto_open macro and have this as the first executable liine:

Debug.Print "AutoOpen Enter: Saved=" & ThisWorkbook.Saved
displays this:
AutoOpen Enter: Saved=False

If I go to Tools-Options... Calculation and set Calculation=manual the
problem goes away. My workbook won't work as I want it if I turn that off,
though.

Any idea wWhat types of forumula will trigger this? I'll keep debugging the
forumulas....

John

"DocBrown" wrote:

I have a workbook that when I open the file and immediately close it, I get
the 'Do you want to save' msgbox.

I insured that the auto_open was disabled. When the file is opened it seems
to have the .Saved property always set to False. I tried to hold the shift
when I open it, same behavior.

What can I check to determine why? I can't figure out what is causing this.

Thanks,
John