Want to Save Popup Started on its own

[Bill]

I have a test file that I put macros in. It has recently
started the pop up "Do you want to save changes in
test.xls" when no changes have been made.

I have no auto macro and the only change before this
started happening was a change to the pagesetup line in
one macro.

What do I look for.

Thanks very much.

 

[Dave R.]

To start, you can look for RAND functions or current date/time functions.

 

[Ken Wright]

From Norman Harker

This is probably because your file contains a volatile function that is
recalculated on opening of the file. The complete list of
volatile functions is:

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()

 

[Bill]

No functions or formulas at all in file

-----Original Message-----
To start, you can look for RAND functions or current date/time functions.

 

[Dave R.]

Any macro code either?

No functions or formulas at all in file

 

[Ken Wright]

Any event macros?

 

[Bill]

I tried it with another sheet and it is a combobox test
that is acting up. Deleting the combobox stops it from
happening.

I wonder why the combobox would do that all of a sudden.