Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the default to "Open" or "New" for a template
Somehow I have changed a default setting that I cannot figure out how to
change back. I have various templates setup in a "Forms" folder. Normally I go to My Documents, find the template file and double click on it, and the appropiate program (usually either Excel or Word) starts and opens a copy of the template as a document. What happens now is that the program starts and the template itself opens. I have tried going to My Documents and right clicking on the file and what appears to be happening is that the default (highlighted) option is "Open" instead of "New" which is what the default used to be. How do I change it back?-- Kord |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the default to "Open" or "New" for a template
Kord
I would try to re-register Excel first. Close Excel first and On the Windows Taskbar 1) StartRun "excel.exe /unregserver"(no quotes)OK. 2) StartRun "excel.exe /regserver"(no quotes)OK. See the space between exe and /regserver You might have to designate a full path to excel.exe. In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK. One more thing to try if any of the above brings no joy......... Go to StartSettingsFolderOptionsFile Types. Scroll down to MS Excel Templatet. Then if running Win98 OS Edit select "New" and Edit. Make sure "New" is the default by it being at top of list and Bolded. If using WinXP OS you would scroll down to XLT then "Advanced"NewEdit. Also make sure "New" is the default action. In Command line the path should be similar to this.... "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e (delete the <sp/e if you want Book1 to open. You must have the double quotes. Below have "use DDE" checked and this in the DDE message box....[open("%1")] Application should read "Excel"(no quotes) Gord Dibben Excel MVP On Wed, 7 Dec 2005 12:28:03 -0800, "Kord" wrote: Somehow I have changed a default setting that I cannot figure out how to change back. I have various templates setup in a "Forms" folder. Normally I go to My Documents, find the template file and double click on it, and the appropiate program (usually either Excel or Word) starts and opens a copy of the template as a document. What happens now is that the program starts and the template itself opens. I have tried going to My Documents and right clicking on the file and what appears to be happening is that the default (highlighted) option is "Open" instead of "New" which is what the default used to be. How do I change it back?-- Kord |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the default to "Open" or "New" for a template
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) ========================== MSWord has the same flags: Close MSWord Windows Start Button|Run winword /unregserver then Windows Start Button|Run winword /regserver (or do that other stuff if this doesn't help.) Kord wrote: Somehow I have changed a default setting that I cannot figure out how to change back. I have various templates setup in a "Forms" folder. Normally I go to My Documents, find the template file and double click on it, and the appropiate program (usually either Excel or Word) starts and opens a copy of the template as a document. What happens now is that the program starts and the template itself opens. I have tried going to My Documents and right clicking on the file and what appears to be happening is that the default (highlighted) option is "Open" instead of "New" which is what the default used to be. How do I change it back?-- Kord -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the default to "Open" or "New" for a template
Dave
I believe OP wants "New" to be the default, which when double-click on an *.XLT file will open Excel with Document1.xls loaded. If "Open" is default, the Template.xlt will open. Gord On Wed, 07 Dec 2005 15:26:32 -0600, 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) ========================== MSWord has the same flags: Close MSWord Windows Start Button|Run winword /unregserver then Windows Start Button|Run winword /regserver (or do that other stuff if this doesn't help.) Kord wrote: Somehow I have changed a default setting that I cannot figure out how to change back. I have various templates setup in a "Forms" folder. Normally I go to My Documents, find the template file and double click on it, and the appropiate program (usually either Excel or Word) starts and opens a copy of the template as a document. What happens now is that the program starts and the template itself opens. I have tried going to My Documents and right clicking on the file and what appears to be happening is that the default (highlighted) option is "Open" instead of "New" which is what the default used to be. How do I change it back?-- Kord |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the default to "Open" or "New" for a template
Oops. I guess I copied the wrong post. But except for the details, the method
is the same <vbg. Except that the OP will rightclick on a .xlt file and make sure it's New as the default. Did I say Oops? Gord Dibben wrote: Dave I believe OP wants "New" to be the default, which when double-click on an *.XLT file will open Excel with Document1.xls loaded. If "Open" is default, the Template.xlt will open. Gord On Wed, 07 Dec 2005 15:26:32 -0600, 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) ========================== MSWord has the same flags: Close MSWord Windows Start Button|Run winword /unregserver then Windows Start Button|Run winword /regserver (or do that other stuff if this doesn't help.) Kord wrote: Somehow I have changed a default setting that I cannot figure out how to change back. I have various templates setup in a "Forms" folder. Normally I go to My Documents, find the template file and double click on it, and the appropiate program (usually either Excel or Word) starts and opens a copy of the template as a document. What happens now is that the program starts and the template itself opens. I have tried going to My Documents and right clicking on the file and what appears to be happening is that the default (highlighted) option is "Open" instead of "New" which is what the default used to be. How do I change it back?-- Kord -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the default to "Open" or "New" for a template
I had already sent a post outlining basically the same info except I directed
OP to the "New" default. Between the two posts OP should get the picture. I'm betting the re-register will fix it anyway. Gord On Wed, 07 Dec 2005 16:14:32 -0600, Dave Peterson wrote: Oops. I guess I copied the wrong post. But except for the details, the method is the same <vbg. Except that the OP will rightclick on a .xlt file and make sure it's New as the default. Did I say Oops? Gord Dibben wrote: Dave I believe OP wants "New" to be the default, which when double-click on an *.XLT file will open Excel with Document1.xls loaded. If "Open" is default, the Template.xlt will open. Gord On Wed, 07 Dec 2005 15:26:32 -0600, 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) ========================== MSWord has the same flags: Close MSWord Windows Start Button|Run winword /unregserver then Windows Start Button|Run winword /regserver (or do that other stuff if this doesn't help.) Kord wrote: Somehow I have changed a default setting that I cannot figure out how to change back. I have various templates setup in a "Forms" folder. Normally I go to My Documents, find the template file and double click on it, and the appropiate program (usually either Excel or Word) starts and opens a copy of the template as a document. What happens now is that the program starts and the template itself opens. I have tried going to My Documents and right clicking on the file and what appears to be happening is that the default (highlighted) option is "Open" instead of "New" which is what the default used to be. How do I change it back?-- Kord |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the default to "Open" or "New" for a template
Thanks alot!!!!!! ureg/reg worked. Thanks again.
-- Kord "Gord Dibben" wrote: Kord I would try to re-register Excel first. Close Excel first and On the Windows Taskbar 1) StartRun "excel.exe /unregserver"(no quotes)OK. 2) StartRun "excel.exe /regserver"(no quotes)OK. See the space between exe and /regserver You might have to designate a full path to excel.exe. In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK. One more thing to try if any of the above brings no joy......... Go to StartSettingsFolderOptionsFile Types. Scroll down to MS Excel Templatet. Then if running Win98 OS Edit select "New" and Edit. Make sure "New" is the default by it being at top of list and Bolded. If using WinXP OS you would scroll down to XLT then "Advanced"NewEdit. Also make sure "New" is the default action. In Command line the path should be similar to this.... "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e (delete the <sp/e if you want Book1 to open. You must have the double quotes. Below have "use DDE" checked and this in the DDE message box....[open("%1")] Application should read "Excel"(no quotes) Gord Dibben Excel MVP On Wed, 7 Dec 2005 12:28:03 -0800, "Kord" wrote: Somehow I have changed a default setting that I cannot figure out how to change back. I have various templates setup in a "Forms" folder. Normally I go to My Documents, find the template file and double click on it, and the appropiate program (usually either Excel or Word) starts and opens a copy of the template as a document. What happens now is that the program starts and the template itself opens. I have tried going to My Documents and right clicking on the file and what appears to be happening is that the default (highlighted) option is "Open" instead of "New" which is what the default used to be. How do I change it back?-- Kord |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default template for a group | Excel Discussion (Misc queries) | |||
Setting a default save folder for a template | Excel Discussion (Misc queries) | |||
Default Template in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel template to load automatically as the default template? | Excel Discussion (Misc queries) | |||
Template in Excel | New Users to Excel |