Prompting to save changes

[Guest]

This isn't a programming question, but there isn't a forum that seems to be specific to this type of problem.

I've got some Excel sheets that I've packed with validation, locked cells, etc. It's password protected and fairly solid. However, every time I open the sheet, even if I don't click into any cells, Excel asks me if I want to save my changes. From what I can tell, it doesnt make a difference whether I answer yes or no.

Does anyone have any idea what could be causing that? It's annoying, quite frankly.

 

[Frank Kabel]

Hi
below a repost from Norman Harker:
-----

You probably have volatile functions in the workbooks:

Some of Excel’s functions are obviously volatile: RAND(), NOW(),
TODAY()

Others are less obviously volatile: OFFSET(), CELL(), INDIRECT(),
INFO() (although the CELL("Filename") function is not volatile)

Some are volatile in some versions of Excel but not in others:
INDEX()became non-volatile in Excel 97.

A number of functions that are documented by Microsoft as volatile do
not actually seem to be volatile when tested:

INDEX(), ROWS(), COLUMNS(), AREAS()

You can download volatileFuncs.zip for a test workbook that shows if a
function is volatile from Charles Williams:

http://www.decisionmodels.com/calcsecretsi.htm

 

[Guest]

Ahhhh. Yes, I think I know what would cause that volatility. Thanks.