View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Diddy Diddy is offline
external usenet poster
 
Posts: 155
Default 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



.