Save changes when no changes?

[wacjac]

Hi,

I've just stumbled upon this most excellent resource!!

I apologise in advance if this is not considered 'correct' by the regulars around here, but I've been perplexed by this annoyance for a good while now;

The speadsheet here HERE (241kb) for some reason has started to insist that I save it upon closing it - even though nothing has been changed and there are no macros embedded.

Would someone be good enough to take a look and put me out of my misery please?

Many thanks

 

[erik.van.geit]

Wacjac,

I just downloaded your file. Opened and closed: no prompt came to ask to save.
What's the problem ?

gegards,
Erik

 

[wacjac]

Very strange.... anyone else get this?

Without doubt it does it on my machine - could it be an option or setting within Excel itself I have enabled or something similar? (Excel 2002)

Edit - Daft question there, I know it can't be a setting as I use dozens of Excel docs each day in my business and this is the only one behaving strangely like this.... anyone??

 

[Tom Urtis]

Take a look very carefully at some things, even if you already have:

(1)
Although you said you do not have date or time formulas, check again, including NOW() or TODAY() formulas.

(2)
Generally, look at any formulas that belong to the Volatile class:
RAND
CELL
AREAS
COLUMNS
ROWS
INDEX
INDIRECT
OFFSET
TODAY
NOW

(3)
Look at paste link formulas that import new data upon open.

(4)
Look at all the modules for code that changes any data upon workbook open, or upon any event.

(5)
Look at charts and named ranges for references to any changes.

(6)
Although you should know what you are saving when asked, this code in the workbook module will automatically save your workbook whenever you close it:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Save
End Sub

 

[pdo]

I too have similar problem and have confirmed that I do not have any of the formulas listed above. How else can you find the source of the changes? Thanks!!!

pdo