One more thing...

If excel is treating the file like a template (*.xlt), then it will add a number
to the workbook name.

Kind of like when you create a new workbook, you'l see book1, book2, book3,
....but there won't be an extension shown in the titlebar. (Do you see the .xls
in the titlebar when you do a File|Open??)

Try that =cell("Filename",a1) business to see if it returns anything. (The file
has to be saved first for this to work.)

<<And you are saving the file as a normal workbook (*.xls), right????

If you are seeing new workbooks (excel/windows is treating it like a template),
then try this:

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.



HannaBlack wrote:

Dave Peterson wrote:
I've never seen excel add a 1 to the filename (from xl95 to xl2003).

But I have seen email clients store attachments in temporary files with an
additional numbers following the file name.

Could it be that someone opened it from an attachment and not the original
workbook? Then the MRU list would be pointed to the file in this temporary
folder.

I like to put:
=cell("Filename",a1)
in an empty cell to see where the file really lives.

If none of this helps, you may want to share the version of excel you're using.
Maybe someone who has had that version has seen the problem and knows a
solution.

Tx, I will try that tomorrow. Well, I think it's Excel 97 but I am not
sure. I asked someone who works in IT (who was in a big hurry) and they
also said they had never seen anything like that before...now I wonder
if it's a bug or something. That's interesting u say Excel doesn't
normally ad a 1 to a filename, perhaps it's more likely that it's not
an excel problem per se.
All I know is that this whole thingamajig is driving me insane!

--

Dave Peterson