Personal.xls

A

AJ

I accidentally closed my Personal.xls file. I can't seem to find it. Is
there a way to reopen it so I don't have to recreate all of my macros? I
tried to reboot my computer thinking the startup process would reopen it but
no luck.
 
S

Shane Devenshire

Hi,

If restarting Excel did not reopen Personal.xls you may have lost it.

But first - it is usually located in the \XLStart folder if you don't find
it there do a Windows search for Personal.xls.
 
D

Dave Peterson

If you just closed that file, then it should open the next time you open excel.

But if it doesn't, then check to see if it's disabled.

In xl2003 menus, you can use:
Help|about MS Excel|Disabled Items.

You can "undisable" it--but if the file is really bad, you may find that you
have to delete it and use a backup version of the file.

In xl2007, I _think_ it's under:
Office button|Excel Options|Addins
select disabled items from the dropdown at the bottom of that window.

=========
If it's not disabled, you could close excel and search for personal.xls.

Windows start button|search
Remember to look for hidden files in hidden folders, too.

If you can't find it that way, then try searching using an old DOS command:

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir personal.xls* /s

The /s says to search subfolders, too.

Make a note of the locations of the found files.

============
This personal.xls file should be stored in your XLStart folder.
 
D

Dave Peterson

ps.

If you find it, make a copy of it and place it in a nice safe location.

You may want to do the same thing with your toolbar file (*.xlb) if you're using
xl2003 or before.
 
A

AJ

Thanks for your help. I was able to relocate it. Thanks for the backup
suggestion. I will make sure to do that.
--
AJ


Dave Peterson said:
ps.

If you find it, make a copy of it and place it in a nice safe location.

You may want to do the same thing with your toolbar file (*.xlb) if you're using
xl2003 or before.
 

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