About the XLStart Folder in Microsoft Excel

First, there are really two Excel Startup folders.

One is created by default when you install the application. Its name is XLStart.

The other is created if you go to ToolsŕOptions, General tab, and enter a location in the At startup... box, shown empty, below.

Tip: Here's where the trouble starts. In prior versions of Excel, it was simply referred to as Alternate Startup folder, which could be very confusing, and people would enter My Documents and other paths in there. Then, when Excel starts up the next time, it tries to open all those files. Ouch!

So, what's it for?

Suppose you are on a network, and the IT department has a macro file from which they want all users to be able to use the macros. They can tell everyone to put a network path in the At Startup box, and they put the macro file (and that's all!) in that network folder.

The XLStart by default is on your PC. If you don't show any path in the At Startup box (or in Alternate Startup Folder in prior versions), then somehow you've placed files in your XLStart folder that don't belong there. Do a search on your hard drive, and find XLStart, and move the files back out of there.

The XLStart folder is also where Adobe Acrobat likes to place itself so that you have Print to PDF buttons on your Excel toolbar.

OfficeArtilces.com debuted on May 26, 2005.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved

Popular Pages