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