What's changing when i open my workbook?

**EdWoods** · 10-06-2011, 01:06 AM

Hi,

I have a large spreadsheet that I have recently substantially altered.

Before I "meddled", if I opened the spreadsheet and closed it, it didn't ask if I want to save (as nothing had changed).

Now, I can't open it and close it without it asking me to save.

If I turn off auto calculation, it won't ask, but I really need it on.

I have checked my formulas (even the one's I didn't change) but see nothing that would change on a recalc if I hadn't changed something myself.

I've tried deleting all instructions in the auto_open macro, but it makes no difference.

This doesn't stop the functionability of the spreadsheet, but is more an annoyance, as I often have to open it, check something then close it.

Any ideas on what could be doing this would be appreciated.

**ConneXionLost** · 10-06-2011, 01:18 AM

Did you add any Volatile Functions?

**EdWoods** · 10-06-2011, 01:23 AM

Don't believe so.

(But maybe I must have?)

**EdWoods** · 10-06-2011, 01:32 AM

Okay, just tested that. I saved the workbook, pressed F9 then exited. It didn't ask to save...

**EdWoods** · 10-06-2011, 02:22 AM

Okay, found my problem, and learnt something.

I had a "countif" function, and had specified the range (from sheet2) as

=countif(sheet1!$a$1:sheet1!$a$5,"test")

I removed the second reference to "sheet1“ so it read

=countif(sheet1!$a$1:$a$5,"test")

Gets the same result, but doesn't now ask to save if I've changed nothing....