ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Saving Changes (https://www.excelbanter.com/excel-discussion-misc-queries/69315-saving-changes.html)

blatham

Saving Changes
 

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


Doug Kanter

Saving Changes
 

"blatham" wrote in
message ...

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

Saving Changes
 
Try also these recent discussions on the same subject:
http://tinyurl.com/9v57j
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"blatham" wrote in
message ...

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

Saving Changes
 

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


--
blatham
------------------------------------------------------------------------
blatham's Profile: http://www.excelforum.com/member.php...o&userid=19441
View this thread: http://www.excelforum.com/showthread...hreadid=508093


Doug Kanter

Saving Changes
 
"blatham" wrote in
message ...

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


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




All times are GMT +1. The time now is 04:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com