How change default sheet?

F

FUBARinSFO

Hi:

When I insert a new worksheet (Insert | Worksheet from menu bar) in an
existing workbook, I want to change the default sheet that gets
inserted. Where is that located? Specifically, I want standard
footers in all the added sheets.

Please note that this is not the same as adding anything to either of
the XLSTART folders, nor the Templates folders.

Thanks in advance for your help.

-- Roy Zider

C:\Program Files\Microsoft Office\OFFICE11\XLSTART
C:\Documents and Settings\Administrator\Application Data\Microsoft
\Excel\XLSTART
C:\Documents and Settings\Administrator\Application Data\Microsoft
\Templates
 
B

Bruce Sinclair

Hi:

When I insert a new worksheet (Insert | Worksheet from menu bar) in an
existing workbook, I want to change the default sheet that gets
inserted. Where is that located? Specifically, I want standard
footers in all the added sheets.

Please note that this is not the same as adding anything to either of
the XLSTART folders, nor the Templates folders.

How is it not ? I have my custom sheet to be inserted in
\MySettings\EXCEL\STARTUP as Sheet.xlxt. In XP using XL 2007, if I click the
'add sheet' tab in the workbook, that's the sheet that gets added.
If that doesn't do what you need, please let us know your OS and XL version.
 
F

FUBARinSFO

How is it not ? I have my custom sheet to be inserted in
\MySettings\EXCEL\STARTUP as Sheet.xlxt. In XP using XL 2007, if I click the
'add sheet' tab in the workbook, that's the sheet that gets added.
If that doesn't do what you need, please let us know your OS and XL version.

I'm using XP SP3 too, first with Excel 2003. "Insert | Worksheet"
from the menu bar inserts the default factory worksheet.

You can of course select a worksheet template, including the factory
sheet "Worksheet" by right-clicking on the sheet tab, clicking/
selecting "Insert..." and then clicking on one of the icons for the
sheet you want. Your sheet (above) will appear as one of the
selections, since you placed it in XLSTART. I'm trying to avoid all
this mousing and clicking around with the simple keyboard insertion,
but can't find the file 'Worksheet" that has all the default factory
settings.

As a further investigation of this problem, I went and installed Excel
2007 on another machine (also running XP SP3). This is even a step
backward, as it seems to have removed the "Insert | Worksheet" path
from its menu bar, rendering the keyboarding impossible (without a VBA
macro, of course, for both instances).

-- Roy Zider

P.S The online Help by Microsoft for Excel 2007 for this situation is
wrong, or at least incomplete since it implies you can do what I'm
trying to do here, which you can't except by mousing and clicking
around from the selection of templates presented to you.
 
F

FUBARinSFO

Bruce:

Hold it -- correction. It does work as you've indicated in Excel
2007. I had dropped the sheet.xltx in the Templates folder as
suggested (?) by the online help, but hadn't tried the other options.

Clicking on the icon by the tabs line (or shift-F11) will insert the
new default sheet.

RE-checking Excel 2003, it does not work that way. It doesn't have
the small add worksheet tab on the tab line, but shift-F11 does insert
a new worksheet. But it is not the changed sheet.xlt in XLSTART
(here, D:\D\DandS\BitBucket\MyDox\_Computer\MSO\My Excel\XLSTART) but
rather the factory default worksheet.

As you might know, in Excel 2003 anthing that is in XLSTART gets
opened when Excel starts, even the .xlt file. So with the sheet.xlt
file as the only file in XLSTART, that's what gets opened as workbook
when you open Excel.

-- Roy
 
B

Bruce Sinclair

Bruce:

Hold it -- correction. It does work as you've indicated in Excel
2007. I had dropped the sheet.xltx in the Templates folder as
suggested (?) by the online help, but hadn't tried the other options.

Clicking on the icon by the tabs line (or shift-F11) will insert the
new default sheet.

That's what happens for me. Took a long time to work out where to put the
file so it would too. Why this should be hard escapes me. I reckon it should
be a simple setting change ("use workbook/worksheet from directory ..."). :)
RE-checking Excel 2003, it does not work that way. It doesn't have
the small add worksheet tab on the tab line, but shift-F11 does insert
a new worksheet. But it is not the changed sheet.xlt in XLSTART
(here, D:\D\DandS\BitBucket\MyDox\_Computer\MSO\My Excel\XLSTART) but
rather the factory default worksheet.

We haven't had 2003 for a while now and I can't recall exactly how that
worked. I do remember it being completely dependent on putting a single
sheet in a particular directory though. Maybe someone still running 2003 can
help here ?
As you might know, in Excel 2003 anthing that is in XLSTART gets
opened when Excel starts, even the .xlt file. So with the sheet.xlt
file as the only file in XLSTART, that's what gets opened as workbook
when you open Excel.

Yep ... and that's not (IIRC :) ) where you put the sheet you want. Might be
close though ... go up one directory and look for 'templates' (? or
something similar ?) ?
You need to put a single sheet workbook called sheet.xlt (again, or similar,
but I do remember it needing to be the template version) wherever the magic
place is. :)

Sorry to be a bit vague, but HTH. :)
 
G

Gord Dibben

As you might know, in Excel 2003 anthing that is in XLSTART gets
opened when Excel starts, even the .xlt file. So with the sheet.xlt
file as the only file in XLSTART, that's what gets opened as workbook
when you open Excel.

Incorrect statement above.

In 2003...............SHEET.XLT stored in XLSTART folder does NOT open when
Excel is started up.

Neither does BOOK.XLT.

*.XLT files in XLSTART folder are ignored.

Design a one-sheet workbook as you wish.

Save as a true Template named SHEET.XLT into your XLSTART folder.

That will be the Insert Sheet default.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top