How do I get my Personal.xls to open everytime I open excel

L

LisaK

My hard drive crashed and had to be re-done. Now I can't seem to get my
Personal.xls workbook to open when I open excel.

Any pointers?

Thanks.
 
R

Ron de Bruin

Hi LisaK

If you have a backup copy it in the XLSTART folder

Where is it:
If it exists, you can find the file in the Excel startup folder.
C:\Documents and Settings\Ron\Application Data\Microsoft\Excel\XLSTART
In Vista look here
C:\Users\Ron\AppData\Roaming\Microsoft\Excel\XLSTART

Note: Ron is the username in the path above

With code you find the correct path on your machine with this line

1) Open excel
2) Hit alt-F11 to get to the VBE
3) Hit ctrl-g to see the immediate window and type this:
4) ?Application.StartupPath

You’ll see the startup path returned


See also
http://www.rondebruin.nl/personal.htm
 
D

Dave Peterson

And just to add to Ron's note...

If that personal.xls is in the correct location (XLStart), then maybe it's been
disabled by excel.

Open excel
Help|About MS Excel|Disabled items

If it's there, you can re-enable it. But if the file is really corrupted, you
may need to restore it from one of your backup versions.
 
R

Ron de Bruin

Thanks Dave

I add it also to my personal.htm page

Excel 97-2003: Help>About MS Excel>Disabled items
Excel 2007 : Office button>Excel Options..Add-ins
In the "Manage:" dropdown (bottom of the dialog)
Choose "Disabled Items
Go
 
D

Dave Peterson

I don't have xl97 or xl2k to test, but I don't remember this feature in those
versions. That doesn't mean that they're not there--but you may want to check.

Or maybe someone running xl97 and xl2k will post back with confirmation either
way????
 
S

Sandy Mann

Speaking for myself, I don't have a *Disabled Items* option in XL97 when I
click on *About Microsoft Excel*

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
D

Dave Peterson

Thanks Sandy.

Anyone using xl2k that can look?

Sandy said:
Speaking for myself, I don't have a *Disabled Items* option in XL97 when I
click on *About Microsoft Excel*

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
R

Ron de Bruin

I will test it this evening in Excel 2000 Dave and update the text
If I remember correct i think it is 2002 that is the first version with this option

I not install Excel 97 anymore (to old)
Thanks Sandy for testing it in 97

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Dave Peterson said:
Thanks Sandy.

Anyone using xl2k that can look?
 
R

Ron de Bruin

2002 is the first version

Excel 2002-2003: Help>About MS Excel>Disabled items
Excel 2007 : Office button>Excel Options..Add-ins
In the "Manage:" dropdown (bottom of the dialog)
Choose "Disabled Items
Go
 
D

Dave Peterson

Thanks for the update, Ron.
2002 is the first version

Excel 2002-2003: Help>About MS Excel>Disabled items
Excel 2007 : Office button>Excel Options..Add-ins
In the "Manage:" dropdown (bottom of the dialog)
Choose "Disabled Items
Go
 
S

Sandy Mann

I not install Excel 97 anymore (to old)

Sorry to hear that you are too old Ron <g>

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


Ron de Bruin said:
I will test it this evening in Excel 2000 Dave and update the text
If I remember correct i think it is 2002 that is the first version with
this option

I not install Excel 97 anymore (to old)
Thanks Sandy for testing it in 97
 
A

Alan

Thanks for the update, Ron.








--

Dave Peterson- Hide quoted text -

- Show quoted text -

Hi,

If the methods above still doesn't work, I think you need to look for
some professional services. You may try Advanced Excel Repair at
http://www.datanumen.com/aer/ This tool is rather useful in salvaging
damaged Excel xls files.

Alan
 

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