Saving Changes

[blatham]

I have a file that always asks whether I want to make changes to it on close even thought I haven't made any.

Can anyone shed any light on the possible cause of this?

Regards

[Doug Kanter]

"blatham" <blatham.22nnfa_1138972801.1636@excelforum-nospam.com> wrote in
message news:blatham.22nnfa_1138972801.1636@excelforum-nospam.com...
>
> I have a file that always asks whether I want to make changes to it on
> close even thought I haven't made any.
>
> Can anyone shed any light on the possible cause of this?
>
> Regards
> blatham


Look for formulae that update when the sheet is opened. =NOW() (the date
formula) is an example. And, is the workbook linked to other workbooks in
some way, even if those workbooks are not open at the time?

[Max]

Try also these recent discussions on the same subject:
http://tinyurl.com/9v57j
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"blatham" <blatham.22nnfa_1138972801.1636@excelforum-nospam.com> wrote in
message news:blatham.22nnfa_1138972801.1636@excelforum-nospam.com...
>
> I have a file that always asks whether I want to make changes to it on
> close even thought I haven't made any.
>
> Can anyone shed any light on the possible cause of this?
>
> Regards
>
>
> --
> blatham
> ------------------------------------------------------------------------
> blatham's Profile:
http://www.excelforum.com/member.php...o&userid=19441
> View this thread: http://www.excelforum.com/showthread...hreadid=508093
>

[blatham]

Yes it was a NOW() formula. Should have realised! Thanks.

[Doug Kanter]

"blatham" <blatham.22nrcy_1138977901.1832@excelforum-nospam.com> wrote in
message news:blatham.22nrcy_1138977901.1832@excelforum-nospam.com...
>
> Yes it was a NOW() formula. Should have realised! Thanks.

That'll be $1.38, please. :-)