View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Excel adds a 1 to the end of the filename.

The 1 indicates you have used the Window | New Window command (so useful
when you want to see two sheets of the same workbook at once, or to view
data in one window and formulas in the other)

Open the one file; use Window and look what files seem to be open. You
should have a .1 and a .2; Make .2 active and close it. Now the .1 at the
end of the filename in the title bar should have gone. Save the workbook.
Reopen and see if all is well. Let us know how it went.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme



"pcgurudude" wrote in message
...
I have EXCEL 2003 SP3.

Whenever I open an existing Excel spreadsheet, Excel automatically adds a
1
to the end. Then when I do a simple "save" it defaults back to "my
documents" instead of the original loacation of the file. Then I have to
navigate back to the original location pick the original file name and
then,
of course, confirm that I want to over write it. This has got to be a
simple
option that I am missing somewhere. HELP!!!