Where's the Personal.xls in Excel 2003?

A

Ariel

I have just upgraded to 2003 and don't know where to put my personal.xls, nor
my .xlb's?

In the 2002 version the personal.xls resided in the C:\Program
Files\Microsoft Office\Office 10\XLStart folder, and

the .xlb's resided in the documents amd settings\name\Application
Dat\Microsoft\Excel

Where do I move my stuff to get it running?
 
S

Stefi

In WindowsXP Prof:
C:\Documents and Settings\your user name\Application
Data\Microsoft\Excel\XLSTART

Regards,
Stefi

„Ariel†ezt írta:
 
B

Bob Phillips

Do application.StartupPath in the immediate window in the VB IDE to find it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
D

Dave Peterson

Just to add...

Excel is pretty smart. If you upgraded over a previous version, you'll find
that excel can still find the previous XLStart folder.

But I'm not that smart. I'd use Bob's suggestion of opening the VBE and hitting
ctrl-g and typing:

?application.startuppath

To find the "latest" location. Then I'd move my personal.xls (and book.xlt and
sheet.xlt and whatever) to this new XLStart location.

For the toolbar, I'd create a new (dummy) toolbar and save it.

Then I'd close excel and use windows|search for *.xlb and move my old toolbar to
that location (wiping out the dummy toolbar).

In some upgrades, it's actually better to rebuild your toolbars from scratch
(icons changed functions--xl95 to xl97 or xl97 to xl2k, IIRC).

It might be worth considering that. You may find that you clean up any garbage
in the XLB file and add/subtract icons from your customized toolbars.

Remember to back up that *.xlb file.
 
A

Ariel

Thanks to you all. I have got it up and running!

Dave Peterson said:
Just to add...

Excel is pretty smart. If you upgraded over a previous version, you'll find
that excel can still find the previous XLStart folder.

But I'm not that smart. I'd use Bob's suggestion of opening the VBE and hitting
ctrl-g and typing:

?application.startuppath

To find the "latest" location. Then I'd move my personal.xls (and book.xlt and
sheet.xlt and whatever) to this new XLStart location.

For the toolbar, I'd create a new (dummy) toolbar and save it.

Then I'd close excel and use windows|search for *.xlb and move my old toolbar to
that location (wiping out the dummy toolbar).

In some upgrades, it's actually better to rebuild your toolbars from scratch
(icons changed functions--xl95 to xl97 or xl97 to xl2k, IIRC).

It might be worth considering that. You may find that you clean up any garbage
in the XLB file and add/subtract icons from your customized toolbars.

Remember to back up that *.xlb file.
 
J

Jim May

Bob:
When I do as you say (in the immediate window)
It returns:

C:\Documents and Settings\Jim May\Application
Data\Microsoft\Excel\XLSTART

When I actually go there - there is NOTHING in the Folder

Actually I happen to know that my XLSTART can be found

C:\Program Files\Microsoft Office\OFFICE11\XLSTART
and includes my Book.xlt and my Personal.xls files

FWIW,,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top