Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Always save as
This has just started happening in the past week. When I open an excel file,
any excel file, it places a 1 at the end of the name and then when I go to save it, it prompts me with the saves as window. I am not sure what is going on, anybody have any ideas. Office 2007 on XP SP3. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Always save as
(saved from a previous post)
This is exactly the way excel treats template (*.xlt) files. If you're saving as a template file, then don't do that anymore. Save as a normal workbook (*.xls). But if you're saving as a normal workbook... Are you opening .xls files by doubleclicking them in windows explorer? And do the workbooks that are opened look like: mybook1 mybook2 .... mybookN (no extension at all???) If all that's true, then it sounds like windows thinks that the file should be treated as a Template. If you rightclick on that file in windows explorer, do you see Open in bold or New in bold? If you see New in bold, then the first thing I'd try is to reregister excel. Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver Then test it out. If that doesn't work... 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) Elie wrote: This has just started happening in the past week. When I open an excel file, any excel file, it places a 1 at the end of the name and then when I go to save it, it prompts me with the saves as window. I am not sure what is going on, anybody have any ideas. Office 2007 on XP SP3. Thanks -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Always save as
Thanks Dave,
I was using workbooks and not templates but I think the reregistering of excel helped. Elie "Dave Peterson" wrote: (saved from a previous post) This is exactly the way excel treats template (*.xlt) files. If you're saving as a template file, then don't do that anymore. Save as a normal workbook (*.xls). But if you're saving as a normal workbook... Are you opening .xls files by doubleclicking them in windows explorer? And do the workbooks that are opened look like: mybook1 mybook2 .... mybookN (no extension at all???) If all that's true, then it sounds like windows thinks that the file should be treated as a Template. If you rightclick on that file in windows explorer, do you see Open in bold or New in bold? If you see New in bold, then the first thing I'd try is to reregister excel. Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver Then test it out. If that doesn't work... 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) Elie wrote: This has just started happening in the past week. When I open an excel file, any excel file, it places a 1 at the end of the name and then when I go to save it, it prompts me with the saves as window. I am not sure what is going on, anybody have any ideas. Office 2007 on XP SP3. Thanks -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Always save as
I figured that windows/excel got mixed up and started treating your workbooks as
templates. If reregistering didn't fix the problem, then the manual technique should fix it. Elie wrote: Thanks Dave, I was using workbooks and not templates but I think the reregistering of excel helped. Elie "Dave Peterson" wrote: (saved from a previous post) This is exactly the way excel treats template (*.xlt) files. If you're saving as a template file, then don't do that anymore. Save as a normal workbook (*.xls). But if you're saving as a normal workbook... Are you opening .xls files by doubleclicking them in windows explorer? And do the workbooks that are opened look like: mybook1 mybook2 .... mybookN (no extension at all???) If all that's true, then it sounds like windows thinks that the file should be treated as a Template. If you rightclick on that file in windows explorer, do you see Open in bold or New in bold? If you see New in bold, then the first thing I'd try is to reregister excel. Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver Then test it out. If that doesn't work... 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) Elie wrote: This has just started happening in the past week. When I open an excel file, any excel file, it places a 1 at the end of the name and then when I go to save it, it prompts me with the saves as window. I am not sure what is going on, anybody have any ideas. Office 2007 on XP SP3. Thanks -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
Save As and save current numbers not the actual formulas and links | Excel Discussion (Misc queries) | |||
how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
when i save xls file, debug script is running and canno't save fil | Excel Discussion (Misc queries) |