Share via

Excel 2019 default startup

Anonymous
2018-12-26T14:07:53+00:00

I have placed my own design workbook in the XLSTART folder also tried creating an alternative start folder (re: advanced settings) but Excel still opens with default 'book 1' Help please?

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-12-26T15:49:53+00:00

    I presume you are talking about workbook and worksheet templates. Then you need to put both Book.xltx and Sheet.xltx in XLSTART.

    How to find XLSTART location -

    C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name, you can directly reach here by copy and pasting following without quotes in Explorer address bar - "%appdata%\Microsoft\Excel")

    Note - If the above path is not applicable for your installation, you need to find XLSTART path. Excel folder contains XLSTART folder in itself (In case, your XLSTART path is not in Appdata)

    Open Excel > ALT+F11 > If Immediate Window is not visible, type CTRL+G. Same can be also be accessed through View > Immediate Window > Type "? application.StartupPath" without quotes and press enter > You will have your path below.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments