Excel falsely asks me to save!

[Julie P.]

Everytime I open a certain Excel doc, even if no changes are made, it asks
me if I want to save when I close it! Even if I open it and instantly decide
to close it!

Why does it do this and how do I get it to stop?

Thanks!

[Don Guillett]

You have an automatic calculation event such as =now() or =today() that
would cause this.
In the ThisWorkbook module you could use
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.Saved = True
End Sub

--
Don Guillett
SalesAid Software
donaldb@281.com
"Julie P." <jporpiglia@hotmail.com> wrote in message
news:dJudnaZKxsTQsevfRVn-jw@comcast.com...
> Everytime I open a certain Excel doc, even if no changes are made, it asks
> me if I want to save when I close it! Even if I open it and instantly
decide
> to close it!
>
> Why does it do this and how do I get it to stop?
>
> Thanks!
>
>
>

[Peo Sjoblom]

Do you have any formulas in it, if so that is the reason

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()

--
Regards,

Peo Sjoblom


"Julie P." <jporpiglia@hotmail.com> wrote in message
news:dJudnaZKxsTQsevfRVn-jw@comcast.com...
> Everytime I open a certain Excel doc, even if no changes are made, it asks
> me if I want to save when I close it! Even if I open it and instantly
> decide to close it!
>
> Why does it do this and how do I get it to stop?
>
> Thanks!
>
>
>

[Julie P.]

"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:%23p9n07xTFHA.2056@tk2msftngp13.phx.gbl...
> Do you have any formulas in it, if so that is the reason
>
> AREAS()
> INDEX()
> OFFSET()
> CELL()
> INDIRECT()
> ROWS()
> COLUMNS()
> NOW()
> TODAY()
> RAND()
>
> --
> Regards,
>
> Peo Sjoblom
>


Hi, thanks Don and Peo!

I checked, and the only formulae I have are

sum
counta
counta(indirect)

so it must be the indirect that is causing it! Thanks!

[Don Guillett]

glad to help

--
Don Guillett
SalesAid Software
donaldb@281.com
"Julie P." <jporpiglia@hotmail.com> wrote in message
news:6s-dnbUBqLX_qevfRVn-pg@comcast.com...
>
> "Peo Sjoblom" <terre08@mvps.org> wrote in message
> news:%23p9n07xTFHA.2056@tk2msftngp13.phx.gbl...
> > Do you have any formulas in it, if so that is the reason
> >
> > AREAS()
> > INDEX()
> > OFFSET()
> > CELL()
> > INDIRECT()
> > ROWS()
> > COLUMNS()
> > NOW()
> > TODAY()
> > RAND()
> >
> > --
> > Regards,
> >
> > Peo Sjoblom
> >
>
>
> Hi, thanks Don and Peo!
>
> I checked, and the only formulae I have are
>
> sum
> counta
> counta(indirect)
>
> so it must be the indirect that is causing it! Thanks!
>
>