Personal.xls ?Save? on exit but no changes
Hi Peter,
It seems to have been =CELL("Filename",A1)
It's the only formula in the Personal wkbk that is an actual formula. All
the example formula are entered as text.
Many thanks for the pointer.
Cheers
Diddy
"Peter T" wrote:
Comment any open event code that modifies the file in some way.
Look for and disable any cell formulas (or named formulas) that include
=Today() or =Now()
Links?
Regards,
Peter T
"Diddy" wrote in message
...
Hi,
I use my Personal.xls to save handy formulas, tips etc. Sometimes if I've
used a piece of code shared on the internet, I'll save the blurb to an
Excel
sheet in Personal.
Recently I get a dialogue box asking if I want to save Personal every time
I
exit Excel even when I know I haven't made changes. I've checked this by
opening a new wkbk and closing immediately.
I did rename Personal a little while ago and saved in another directory
because I wondered if it was slowing the loading of Excel on my machine.
It
wasn't so I deleted the Personal in XLSTART and copied the original
Personal
back in and renamed it.
If anyone can help I would be grateful :-)
Cheers
Diddy
.
|