Start Free Trial
Excel startup folder in Windows 7
I’m switching computers, from XP to Windows 7 and from Office 2003 to 2010. In XP I use an Excel Startup folder. I can’t find and Excel Startup file in Windows 7. Does anyone know where to find it?
Microsoft Legacy OS
8/22/2022 - Mon
In Excel, File, Options, Save. The folder I assign there is the folder Excel uses to open files from. This is (roughly) the same in Word, Powerpoint, etc (all V2010). .... Thinkpads_User
FOR INDIVIDUAL USERS:
In Vista or Windows 7 look here
You can also use:
If you want code made available in all your workbooks, then use your
PERSONAL.XLS or in Excel 2007-2010 your PERSONAL.XLSB file.
GLOBAL (ALL USERS):
C:\Program Files\Microsoft Office\Office14\XLSTART
ALTERNATIVE (CUSTOM FOLDER):
There is an alternative method to set a startup file in Excel 2007/2010. Within the Excel options you can specify the startup file from any folder. To do this choose the Office Button or File tab, Excel Options, Advanced, scroll down to the General section and you'll see "At startup, open all files in" - enter the chosen folder location into the box. So here you can specify your own Excel startup folder.
For the record, I’m the admin on this computer with access to hidden files. I followed the path below and didn’t find XLSTART:
I created an XLSTART folder here and copied my Excel files to it. They didn’t open when I opened Excel. I did some more research online and tried following location instead:
C:\Program Files (x86)\Microsoft Office\Office14\XLSTART
I tried this folder and my Excel files opened. Do you see any problems with this method I used?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
I'm aware of the USERID tag. Like you, not sure why your method didn't work, but ours is not to question why...
Thanks for your help and the note about all users versus just me.
Plans and Pricing
Certified Expert Program
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent