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?
GregMcKimAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
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
0
n2fcCommented:
FOR INDIVIDUAL USERS:
=========================

In Vista or Windows 7 look here
C:\Users\{USERID}\AppData\Roaming\Microsoft\Excel\XLSTART

You can also use:
PERSONAL.XLS(B)

 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.
0
GregMcKimAuthor Commented:
n2fc:

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:

C:\Users\{USERID}\AppData\Roaming\Microsoft\Excel\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?
0
n2fcCommented:
The latter (in Program Files or Program Files (x86) for 32 under 64) will work for any logged in user...

The tag {USERID} (obviously) should be replaced with the user id of the account to be affected individually...

Not sure why the first option failed for you, but if it is OK for all users to get this feature, of course the other option is perfectly fine!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GregMcKimAuthor Commented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Hardware

From novice to tech pro — start learning today.