Prompt to save on closing

J

Jake

Hi,
When I open an Excel file and close it, without making any changes, it
always prompts to save. There are no links in the file and no code either;
nothing I can find that causes this.
Any ideas?
Thanks,
Jake
 
R

Ron de Bruin

Maybe you have Volatile functions like

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

Jake

Thanks Ron, I hadn't thought of that, but unfortunately my file doesn't
contain any of those functions.
Jake
 
R

Ron de Bruin

Maybe

Dave Peterson posted this :

Excel likes to recalculate workbooks created in earlier versions. Is this
the case in your situation?
 
J

Jake

Thanks again Ron, this doesn't seem to be the problem either. Thanks for
the help though
Jake
 
R

Ron de Bruin

Hi Jake

If you want you can send me the workbook (private)
I will look at it for you then
 
R

Ron de Bruin

Hi all

There are comboboxes on the sheet with a linkedcell and a listfillrange.
That is the reason why it always prompts to save.
 
Top