Where's the Personal.xls in Excel 2003?
Thanks to you all. I have got it up and running!
"Dave Peterson" wrote:
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.
Ariel wrote:
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?
--
Dave Peterson
|