Share via

XLTM saved in Excel/XLSTART

Anonymous
2019-04-26T17:09:06+00:00

XLSTART is a trusted location, it is my start up folder, and I have tried repairing my office 365 installation as was suggested here: 

https://support.office.com/en-us/article/Customize-how-Excel-starts-6509b9af-2cc8-4fb6-9ef5-cf5f1d292c19

However, my XLTM file still does not load on start up.  Will you please tell me how to get it to load?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

10 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2019-04-27T09:55:37+00:00

    The whole secret is to read the article you mention EXACTLY:

    [quote]

    To automatically open a specific workbook when you start Excel, you can place that workbook in the XLStart folder, or you can use an alternate startup folder in addition to the XLStart folder.

    [/quote]

    It says "workbook" not "template":

    [quote]

    To use a worksheet template, create a workbook that contains one worksheet. On the worksheet, include the formatting, styles, text, and other information that you want to appear on all new worksheets that will be based on the worksheet template.

    [/quote]

    Andreas.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2019-04-26T18:15:08+00:00

    Yes, I am.

    Was this answer helpful?

    0 comments
  3. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2019-04-26T17:58:51+00:00

    Start Excel > File > Options > Save > Are you saving this in whatever is specified in Default personal templates location

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-04-26T17:44:18+00:00

    Correct, I have tried that process (Book.xltm in the templates folder) as well as saving book.xltm in XLSTART.  Neither worked.

    Was this answer helpful?

    0 comments
  5. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2019-04-26T17:17:47+00:00

    Hi CharlesFox4

    Greetings! I am Vijay, an Independent Advisor. I am here to work with you on this problem.

    Looks like you want to loadt template. Are you following this process in above link - Automatically open a workbook template or worksheet template when you start Excel

    Do let me know if you require any further help on this. Will be glad to help you.

    Was this answer helpful?

    0 comments