Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
joyce
 
Posts: n/a
Default how do I change an excel template into a "workbook"

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   Report Post  
JulieD
 
Posts: n/a
Default

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   Report Post  
joyce
 
Posts: n/a
Default

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   Report Post  
JulieD
 
Posts: n/a
Default

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   Report Post  
joyce
 
Posts: n/a
Default

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   Report Post  
JulieD
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel template to load automatically as the default template? David Excel Discussion (Misc queries) 1 March 21st 05 12:24 PM
Excel workbook JdeValk Excel Worksheet Functions 1 March 18th 05 06:30 AM
Excel: Use a name with external workbook reference for data valida Fishyken Excel Worksheet Functions 3 March 11th 05 10:24 PM
Excel should have a quick and simple "change case" function like . NinaSvendsen Excel Worksheet Functions 1 January 28th 05 03:15 PM
Macro in Excel 2002 to save a workbook to a FTP location Lloyd Excel Discussion (Misc queries) 0 December 21st 04 02:49 PM


All times are GMT +1. The time now is 06:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"