Excel asking for save with no changes

[tommy20]

Removing the =NOW() did the trick. Thanks!

Any insight on the other problem?

On a separate matter, some of these files contain "automatic link to
information in another workbook", which causes a popup asking if the
reader wants that information updated. Is there a way to disabl this
at the workbook level, so it defaults to no update (keeping the last
saved information)? I would even be open to a method that "locks the
file (doing away with the links), if that's the only way. Manually
replacing all of them with the data is not really an option, though,
due to the size of the workbooks.

-Tomm

 

[Dave Peterson]

Saved from a similar question:

The links question:

You can toggle the setting (user by user, though) via:

Tools|Options|Edit Tab.
There's a checkmark for "ask to update automatic links"

But this means that you suppress the question--the links still get updated.

This setting is for the individual user--and affects all their workbooks.

If you want more control:
Try creating a dummy workbook whose only purpose is to open the original
workbook with links updated:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=1
ThisWorkbook.Close savechanges:=False
End Sub

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)

And xl2002 added an option that allows you to have more control:
Edit|links|startup prompt button.
check the "don't display the alert and update links"