1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 97 Default Workbook/Sheets

Discussion in 'Business Applications' started by dmcclure, Nov 26, 2001.

Thread Status:
Not open for further replies.
Advertisement
  1. dmcclure

    dmcclure Thread Starter

    Joined:
    Jul 29, 1999
    Messages:
    142
    It seems to me that I used to be able to set up my own default Excel books and worksheets. I would set formats, toolbars, footers, etc. the way I liked them then save the sheet as “sheet1.xlt” and the workbook as “book1.xlt”, and put these in the XLstart folder. That way, when I opened a new workbook, or inserted a new sheet, the sheets are formatted they way I want them. But that doesn’t seem to work now. I’m using Excel 97 and Win XP. Before I was using Excel 97 and Win98. Did I miss a cog somewhere? It’s been a long time since I did this and perhaps I missed a step.

    Don
     
  2. Gurnerworld

    Gurnerworld

    Joined:
    Dec 18, 2000
    Messages:
    124
    Hi Don,

    You're almost there!

    The default workbook must be called book.xlt and not book1.xlt

    That should solve your problem.
     
  3. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    And you don't save a sheet1.xlt--there is no such thing.

    Just right-click on sheet1 of a blank file, hit Select all sheets. Format as desired. Save the file as book1.xlt in the XLSTART. Close Excel and relaunch to test.

    (Hi mikey!)
     
  4. Gurnerworld

    Gurnerworld

    Joined:
    Dec 18, 2000
    Messages:
    124
    Hi Dreamy,

    Can I re-confirm that the book needs to be saved as Book.xlt and not book1.xlt

    Tres important and the cause of much frustration.
     
  5. dmcclure

    dmcclure Thread Starter

    Joined:
    Jul 29, 1999
    Messages:
    142
    The correct name is book.xlt. Furthermore, if there is more than one sheet in your book be sure all are formatted the way you want them. For example, if you want your own footer to appear on each sheet you must add it to each sheet, then save the template. Also, if you want Inserted sheets to be set up the same way, then go to Save As and save "sheet.xlt". It works just like book.xlt in that it saves your settings for inserted sheets. One other thing: My Excel default for saving Excel templates is "Microsoft Office/Templates". Unfortunately, Excel looks for its templates in "Microsoft Office/Office/XLStart". Be sure and save your Excel templates there.

    Don
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/59747

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice