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.


HannaBlack wrote:

I need some help here.
At work, I need to use an excel sheet and I realized to my horror
(weirdly enough I was the first to notice) that if you opened the excel
sheet in "my recent documents", it would open the document with a small
"1" after its original name, but not the actual document. Apparently no
one before me had noticed the small number after the file name, and had
gone on saving half a dozen different excel sheets when there should be
only one!

I deleted all the files that weren't my original one but when I went to
"my recent documents" it would restore that deleted file if I
double-clicked on it. None of this happens if I open the file in Excel.

First I thought that maybe I had saved my document as a template, but
that wasn't so, neither is it a read-only. Yet each time I want to open
MY document in "my recent documents", Excel (and only Excel) opens a
copy of the document and not the real document. If this copy of my
document is open, and I select the file again from "my recent
documents", it will open yet ANOTHER copy of the document.

I have no idea what the problem could be...does anyone here?

--

Dave Peterson