Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I run office 2003 and have created an Excel workbook and saved it as a
"template" in a folder on the desk top. I have now opened this template and attempted to re-save it as an "Excel work book " in a new folder so as to use it, but when I close this new work book copy it closes as a "file" not a work book. What is happening here and how do I get excel to save it as a new "workbook" -- JB |
#2
![]() |
|||
|
|||
![]()
Hi Joyce
to use a template you don't open it and save it, you open a new workbook based on the template ... so starting from scratch the process is create a workbook save it as a template - file / save as ... change save as type to template - leave the location to whatever excel defaults to close the file to use it file /new on 2003 choose On My Computer under Templates on the task pane choose your template OK and excel will create a new workbook based on your template hope this helps -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "joyce" wrote in message ... I run office 2003 and have created an Excel workbook and saved it as a "template" in a folder on the desk top. I have now opened this template and attempted to re-save it as an "Excel work book " in a new folder so as to use it, but when I close this new work book copy it closes as a "file" not a work book. What is happening here and how do I get excel to save it as a new "workbook" -- JB |
#3
![]() |
|||
|
|||
![]()
Hi Julie,
I saved the work book I had created as a "template" as you sugested and sent it off to the default excel template folder, but when I went to open a new workbook based on this template it was not in the default template folder. I then went into this folder to find the workbook there but instead of it being a template as I had saved it, it was once again a "file" extention. "JulieD" wrote: Hi Joyce to use a template you don't open it and save it, you open a new workbook based on the template ... so starting from scratch the process is create a workbook save it as a template - file / save as ... change save as type to template - leave the location to whatever excel defaults to close the file to use it file /new on 2003 choose On My Computer under Templates on the task pane choose your template OK and excel will create a new workbook based on your template hope this helps -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "joyce" wrote in message ... I run office 2003 and have created an Excel workbook and saved it as a "template" in a folder on the desk top. I have now opened this template and attempted to re-save it as an "Excel work book " in a new folder so as to use it, but when I close this new work book copy it closes as a "file" not a work book. What is happening here and how do I get excel to save it as a new "workbook" -- JB |
#4
![]() |
|||
|
|||
![]()
Hi Joyce
i have never seen this problem .. could you create a test template from scratch and follow the steps outlined i my previous email and see what happens with this one ... btw by "file" extension i guess you mean a *.xls as opposed to a *.xlt extension of a template. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "joyce" wrote in message ... Hi Julie, I saved the work book I had created as a "template" as you sugested and sent it off to the default excel template folder, but when I went to open a new workbook based on this template it was not in the default template folder. I then went into this folder to find the workbook there but instead of it being a template as I had saved it, it was once again a "file" extention. "JulieD" wrote: Hi Joyce to use a template you don't open it and save it, you open a new workbook based on the template ... so starting from scratch the process is create a workbook save it as a template - file / save as ... change save as type to template - leave the location to whatever excel defaults to close the file to use it file /new on 2003 choose On My Computer under Templates on the task pane choose your template OK and excel will create a new workbook based on your template hope this helps -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "joyce" wrote in message ... I run office 2003 and have created an Excel workbook and saved it as a "template" in a folder on the desk top. I have now opened this template and attempted to re-save it as an "Excel work book " in a new folder so as to use it, but when I close this new work book copy it closes as a "file" not a work book. What is happening here and how do I get excel to save it as a new "workbook" -- JB |
#5
![]() |
|||
|
|||
![]()
Hi Julie,
I have created another template using the method you outlined (a single page this time not a workbook) and the good news, is that it turned up in the default template folder this time as a "template" file, but when I used it to create a new work book and saved this as an "excel work book" the new work book icon and properties were again that of a "file" type file not an "excel work book" type file which was what I had saved it as. I guess we are making some progress in this. Regards "JulieD" wrote: Hi Joyce i have never seen this problem .. could you create a test template from scratch and follow the steps outlined i my previous email and see what happens with this one ... btw by "file" extension i guess you mean a *.xls as opposed to a *.xlt extension of a template. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "joyce" wrote in message ... Hi Julie, I saved the work book I had created as a "template" as you sugested and sent it off to the default excel template folder, but when I went to open a new workbook based on this template it was not in the default template folder. I then went into this folder to find the workbook there but instead of it being a template as I had saved it, it was once again a "file" extention. "JulieD" wrote: Hi Joyce to use a template you don't open it and save it, you open a new workbook based on the template ... so starting from scratch the process is create a workbook save it as a template - file / save as ... change save as type to template - leave the location to whatever excel defaults to close the file to use it file /new on 2003 choose On My Computer under Templates on the task pane choose your template OK and excel will create a new workbook based on your template hope this helps -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "joyce" wrote in message ... I run office 2003 and have created an Excel workbook and saved it as a "template" in a folder on the desk top. I have now opened this template and attempted to re-save it as an "Excel work book " in a new folder so as to use it, but when I close this new work book copy it closes as a "file" not a work book. What is happening here and how do I get excel to save it as a new "workbook" -- JB |
#6
![]() |
|||
|
|||
![]()
Hi Joyce
have you run detect & repair from the help menu? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "joyce" wrote in message ... Hi Julie, I have created another template using the method you outlined (a single page this time not a workbook) and the good news, is that it turned up in the default template folder this time as a "template" file, but when I used it to create a new work book and saved this as an "excel work book" the new work book icon and properties were again that of a "file" type file not an "excel work book" type file which was what I had saved it as. I guess we are making some progress in this. Regards "JulieD" wrote: Hi Joyce i have never seen this problem .. could you create a test template from scratch and follow the steps outlined i my previous email and see what happens with this one ... btw by "file" extension i guess you mean a *.xls as opposed to a *.xlt extension of a template. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "joyce" wrote in message ... Hi Julie, I saved the work book I had created as a "template" as you sugested and sent it off to the default excel template folder, but when I went to open a new workbook based on this template it was not in the default template folder. I then went into this folder to find the workbook there but instead of it being a template as I had saved it, it was once again a "file" extention. "JulieD" wrote: Hi Joyce to use a template you don't open it and save it, you open a new workbook based on the template ... so starting from scratch the process is create a workbook save it as a template - file / save as ... change save as type to template - leave the location to whatever excel defaults to close the file to use it file /new on 2003 choose On My Computer under Templates on the task pane choose your template OK and excel will create a new workbook based on your template hope this helps -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "joyce" wrote in message ... I run office 2003 and have created an Excel workbook and saved it as a "template" in a folder on the desk top. I have now opened this template and attempted to re-save it as an "Excel work book " in a new folder so as to use it, but when I close this new work book copy it closes as a "file" not a work book. What is happening here and how do I get excel to save it as a new "workbook" -- JB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel template to load automatically as the default template? | Excel Discussion (Misc queries) | |||
Excel workbook | Excel Worksheet Functions | |||
Excel: Use a name with external workbook reference for data valida | Excel Worksheet Functions | |||
Excel should have a quick and simple "change case" function like . | Excel Worksheet Functions | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |