Results 1 to 13 of 13
  1. #1
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    New Sheet Names with Sheet Templates (97 SR-2)

    I've set up a sheet.xlt file and it works fine except for one thing. When I add new sheets to my workbook, it always names then Sheet1. As I insert more sheets, they are named Sheet1(2), Sheet1(3), etc. Is there any way to get the new sheets to be named Sheet2, Sheet3, etc. as before?

  2. #2
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Sheet Names with Sheet Templates (97 SR-2)

    It sounds like you are creating new sheets by copying the original Sheet1, i.e. via edit | move or copy sheet,
    rather than by actually inserting a new worksheet, i.e. via insert | worksheet.

    stuck

  3. #3
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Sheet Names with Sheet Templates (97 SR-2)

    I suppose that would give the same problem, but that's not what I'm doing. I'm just doing insert|worksheet.

  4. #4
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Sheet Names with Sheet Templates (97 SR-2)

    I just saved a new wkb as a template. then reopened it and clicked Insert-Worksheet

    The new sheet was Sheet4 (started with 1-3). So I can't duplicate your problem
    I didn't try it with worksheet protection....don't know if that would change things

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Sheet Names with Sheet Templates (97 SR-2)

    Excel 2000 exhibits the same behaviour I'm afraid.
    I know no way to prevent this from happening.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: New Sheet Names with Sheet Templates (97 SR-2)

    Get Excel 2002 <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

  7. #7
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Sheet Names with Sheet Templates (97 SR-2)

    I don't follow...

    I've got loads of XL97 sr2 .xlt files and none of them show the original problem described by chipshot. They all behave the way the std blank workbook behaves, i.e. insert | worksheet creates sheet2, sheet 3 etc. and edit | move or copy creates sheet1 (2) sheet1(3) etc. Like GoCush I cannot recreate the effect where insert | worksheet names the new sheet as if it were a copy of the original.

    stuck

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Sheet Names with Sheet Templates (97 SR-2)

    I did it like this:

    - Remove all but one sheet (called Sheet1)
    - File, Save-as, filetype Template, filename Sheet (extension wil be added by Excel). Location: XLStart.

    Works fine with XL2000.

    The repeated this for my XL97 SR2. First it did exactly what you described earlier : "Sheet1 (1)".
    Then I reloaded XL97 and got exactly what XL2000 does: it names the sheet as it should, if I have Sheet1 ..Sheet4 I get Sheet5.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: New Sheet Names with Sheet Templates (97 SR-2)

    Apparently, Excel 97, 2000 and 2002 handle inserting new worksheets based on sheet.xlt correctly for most of us, but there seems to be the occasional glitch. Also see Pieterse's reply immediately below yours.

  10. #10
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: New Sheet Names with Sheet Templates (97 SR-2)

    I do not know what else you did, but I keep having the same problem with XL97 that is reported (even after restarting XL and rebooting). These are 3 different machines running XP, Win2000, Win95.

    The only way I found to have the new sheet be named correctly was to use VB:
    Worksheets.add

    but (I think) this works since using VB did not add the template sheet but the "default one". Adding the "custom sheet" only seems to come from insert worksheets, and has the problem with the names in XL97.

    Microsoft has a "workaround" to the problem: rename the sheets, though it seems to have been fixed in later versions.

    Steve

  11. #11
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: New Sheet Names with Sheet Templates (97 SR-2)

    Do you have a template named "sheet.xlt" as opposed to a "workbook template".
    The problem is with the sheet template (and there is only one: it is named sheet.xlt and is in xlstart folder or the alt startup directory).

    When you have a sheet.xlt file, the name you give the sheet is used as the name for the new worksheet and it adds the "suffix" if that name already exists.

    Steve

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Sheet Names with Sheet Templates (97 SR-2)

    You're right, I am unable to reproduce my previous success.
    Great stuff this <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> .
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  13. #13
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Sheet Names with Sheet Templates (97 SR-2)

    Thanks for everyone's help on this. It appears to be a non-solvable problem. The IT gods obviously don't give me the power to unilaterally upgrade from xl97. I think I'll keep using my sheet.xlt anyway and rename sheets. I usually don't keep the default sheet names anyway since I like to be more descriptive.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •