Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I stop Excel from saving a file with a different name?
When I change an existing XL file and then try to save it, XL wants to save
it as the original file name with a 1 appended. Previously XL did not do this: it saved it with the same name and in the same folder where the original file was. Now it wants to save this file with the new name in My Documents. |
#2
|
|||
|
|||
Sounds like you've got a template there, Gary. Either that or there's a
macro in the file that's saving it this way. ************ Anne Troy www.OfficeArticles.com "Gary" wrote in message ... When I change an existing XL file and then try to save it, XL wants to save it as the original file name with a 1 appended. Previously XL did not do this: it saved it with the same name and in the same folder where the original file was. Now it wants to save this file with the new name in My Documents. |
#3
|
|||
|
|||
I checked the file extension; it is .xls not .xlt for template. Seems to do
this for many of my existing XL files. "Anne Troy" wrote: Sounds like you've got a template there, Gary. Either that or there's a macro in the file that's saving it this way. ************ Anne Troy www.OfficeArticles.com "Gary" wrote in message ... When I change an existing XL file and then try to save it, XL wants to save it as the original file name with a 1 appended. Previously XL did not do this: it saved it with the same name and in the same folder where the original file was. Now it wants to save this file with the new name in My Documents. |
#4
|
|||
|
|||
Try opening one of your files (and do you open them by double clicking on them
in windows explorer???) Put this in an empty cell: =cell("filename",a1) What do you get back? If the cell returns the name of the file (including the path), then ignore the rest of this message... But if the cell looks empty, then excel is seeing your .xls file as a template. Saved from a previous post: =========================== 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) Gary wrote: I checked the file extension; it is .xls not .xlt for template. Seems to do this for many of my existing XL files. "Anne Troy" wrote: Sounds like you've got a template there, Gary. Either that or there's a macro in the file that's saving it this way. ************ Anne Troy www.OfficeArticles.com "Gary" wrote in message ... When I change an existing XL file and then try to save it, XL wants to save it as the original file name with a 1 appended. Previously XL did not do this: it saved it with the same name and in the same folder where the original file was. Now it wants to save this file with the new name in My Documents. -- Dave Peterson |
#5
|
|||
|
|||
I think I found a way to solve problem. Went to Control Panel/Folder
Options/File Types and then selected XLS. I clicked on Advanced and highlighted "Open" then I clicked on "Set Default." This seems to have fixed the problem. "Dave Peterson" wrote: Try opening one of your files (and do you open them by double clicking on them in windows explorer???) Put this in an empty cell: =cell("filename",a1) What do you get back? If the cell returns the name of the file (including the path), then ignore the rest of this message... But if the cell looks empty, then excel is seeing your .xls file as a template. Saved from a previous post: =========================== 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) Gary wrote: I checked the file extension; it is .xls not .xlt for template. Seems to do this for many of my existing XL files. "Anne Troy" wrote: Sounds like you've got a template there, Gary. Either that or there's a macro in the file that's saving it this way. ************ Anne Troy www.OfficeArticles.com "Gary" wrote in message ... When I change an existing XL file and then try to save it, XL wants to save it as the original file name with a 1 appended. Previously XL did not do this: it saved it with the same name and in the same folder where the original file was. Now it wants to save this file with the new name in My Documents. -- Dave Peterson |
#6
|
|||
|
|||
I think reregistering excel is quicker and safer and easier to try -- so I'd use
that first. And going through the control panel or going through windows explorer seem pretty much equivalent to me. Gary wrote: I think I found a way to solve problem. Went to Control Panel/Folder Options/File Types and then selected XLS. I clicked on Advanced and highlighted "Open" then I clicked on "Set Default." This seems to have fixed the problem. "Dave Peterson" wrote: Try opening one of your files (and do you open them by double clicking on them in windows explorer???) Put this in an empty cell: =cell("filename",a1) What do you get back? If the cell returns the name of the file (including the path), then ignore the rest of this message... But if the cell looks empty, then excel is seeing your .xls file as a template. Saved from a previous post: =========================== 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) Gary wrote: I checked the file extension; it is .xls not .xlt for template. Seems to do this for many of my existing XL files. "Anne Troy" wrote: Sounds like you've got a template there, Gary. Either that or there's a macro in the file that's saving it this way. ************ Anne Troy www.OfficeArticles.com "Gary" wrote in message ... When I change an existing XL file and then try to save it, XL wants to save it as the original file name with a 1 appended. Previously XL did not do this: it saved it with the same name and in the same folder where the original file was. Now it wants to save this file with the new name in My Documents. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
Backup in Saving a file in Excel 2002 | Excel Discussion (Misc queries) | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel |