Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Fails to open template
My workgroup templates are Excel97 and Excel 2003 won't open them. No error
it just doesn't open them. Even if I save a new template in 2003 and save it to the workgroup location it fails to open. They can be seen in the open dialog box. The workgroup location is on a Netware, but that shouldn't matter as they are in P:\MSOFFICE\XLSTART\TEMPLATE If I move them to the same folder as the Word Templates then they open, but the File extension is displayed. This can't be by design. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Fails to open template
First, I don't have a network to test--so this is just a suggestion and may not
help. I'd check the templates path and the network templates path to make sure that they point to the correct location. (The .templatespath isn't your problem--but it may be interesting to see???) You could run a macro and look in the immediate window: Option Explicit Sub testme() With Application Debug.Print .TemplatesPath & vbLf & .NetworkTemplatesPath End With End Sub If the network templates path points at the incorrect location, you can change it in MSWord--excel doesn't offer a way to get to that path. If it points at the correct location, are you sure you're using it correctly. I'm not sure what you mean by the Open dialog box. I would think you'd want the File|New dialog (or Task Pane). If you don't like that task pane, you could use a macro to show the old style interface: Option Explicit Sub testme2() Application.Dialogs(xlDialogWorkbookNew).Show End Sub Geroge wrote: My workgroup templates are Excel97 and Excel 2003 won't open them. No error it just doesn't open them. Even if I save a new template in 2003 and save it to the workgroup location it fails to open. They can be seen in the open dialog box. The workgroup location is on a Netware, but that shouldn't matter as they are in P:\MSOFFICE\XLSTART\TEMPLATE If I move them to the same folder as the Word Templates then they open, but the File extension is displayed. This can't be by design. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Fails to open template
The Path is set correctly as the templates can be seen in the Open|New
Template Dialog. They just won't open. I can select them without anything happening. "Dave Peterson" wrote: First, I don't have a network to test--so this is just a suggestion and may not help. I'd check the templates path and the network templates path to make sure that they point to the correct location. (The .templatespath isn't your problem--but it may be interesting to see???) You could run a macro and look in the immediate window: Option Explicit Sub testme() With Application Debug.Print .TemplatesPath & vbLf & .NetworkTemplatesPath End With End Sub If the network templates path points at the incorrect location, you can change it in MSWord--excel doesn't offer a way to get to that path. If it points at the correct location, are you sure you're using it correctly. I'm not sure what you mean by the Open dialog box. I would think you'd want the File|New dialog (or Task Pane). If you don't like that task pane, you could use a macro to show the old style interface: Option Explicit Sub testme2() Application.Dialogs(xlDialogWorkbookNew).Show End Sub Geroge wrote: My workgroup templates are Excel97 and Excel 2003 won't open them. No error it just doesn't open them. Even if I save a new template in 2003 and save it to the workgroup location it fails to open. They can be seen in the open dialog box. The workgroup location is on a Netware, but that shouldn't matter as they are in P:\MSOFFICE\XLSTART\TEMPLATE If I move them to the same folder as the Word Templates then they open, but the File extension is displayed. This can't be by design. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2000 fails to open excel 2003 file | Excel Discussion (Misc queries) | |||
Workbook fails to open - Excel 2003 | Excel Discussion (Misc queries) | |||
Button fails to call macro when open an Excel via Intranet | Excel Discussion (Misc queries) | |||
Excel Template fails to open??? | Excel Discussion (Misc queries) | |||
Unable to open Template in Excel 2003 | Excel Discussion (Misc queries) |