Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel assigns "1" after the filename
When I open an existing file, Excel automatically appends the file name with
a "1" after the name. This has recently started happening. I have no idea why or how to stop it! Any advice??? |
#2
|
|||
|
|||
Excel assigns "1" after the filename
it is thinking your file is a template.
open the file and use save as and insure it is not saving as a template. "sostabarak" wrote: When I open an existing file, Excel automatically appends the file name with a "1" after the name. This has recently started happening. I have no idea why or how to stop it! Any advice??? |
#3
|
|||
|
|||
Excel assigns "1" after the filename
Saved from a previous post:
=========================== Are you opening a template file (*.xlt) or a normal workbook file (*.xls)? If you're opening a template file, then this is the way excel works--so you don't overwrite that template. If you're opening an excel file, then excel/windows is confused. It sounds like windows is using New as the default action when you doubleclick on the filename in windows explorer. If you right click on a *.xls file, you'll see a bunch of options--one will be Open and one will be New. Open should be the bold (default) one. I bet you'll see New in bold. If that's the case, you can 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. Now try double clicking on that filename. Did it work ok? If yes, woohoo! If no, you could manually change the default action. Close excel start windows explorer tools|folder options|file types tab scroll down to the xls extension (microsoft excel worksheet) click the advanced button click on the Open item in the Actions box click set as default (ok your way out) sostabarak wrote: When I open an existing file, Excel automatically appends the file name with a "1" after the name. This has recently started happening. I have no idea why or how to stop it! Any advice??? -- Dave Peterson |
#4
|
|||
|
|||
Excel assigns "1" after the filename
"Dave Peterson" wrote: Saved from a previous post: =========================== Are you opening a template file (*.xlt) or a normal workbook file (*.xls)? If you're opening a template file, then this is the way excel works--so you don't overwrite that template. If you're opening an excel file, then excel/windows is confused. It sounds like windows is using New as the default action when you doubleclick on the filename in windows explorer. If you right click on a *.xls file, you'll see a bunch of options--one will be Open and one will be New. Open should be the bold (default) one. I bet you'll see New in bold. If that's the case, you can 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. Now try double clicking on that filename. Did it work ok? If yes, woohoo! If no, you could manually change the default action. Close excel start windows explorer tools|folder options|file types tab scroll down to the xls extension (microsoft excel worksheet) click the advanced button click on the Open item in the Actions box click set as default (ok your way out) sostabarak wrote: When I open an existing file, Excel automatically appends the file name with a "1" after the name. This has recently started happening. I have no idea why or how to stop it! Any advice??? -- Dave Peterson Excellent advice ..worked beautifully thank you! |
#5
|
|||
|
|||
Excel assigns "1" after the filename
"bj" wrote: it is thinking your file is a template. open the file and use save as and insure it is not saving as a template. "sostabarak" wrote: When I open an existing file, Excel automatically appends the file name with a "1" after the name. This has recently started happening. I have no idea why or how to stop it! Any advice??? Thank you for the input..unfortunately it didn't work..however I did get a solution which is posted. Thank you!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
why does excel 2002 add a '1' to the filename everytime I open a f | Excel Discussion (Misc queries) | |||
Microsoft Excel in Microsoft works - how to open | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |