Finding the Personal.xls file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave K - 06 Feb 2008 22:33 GMT

Hello - Does anyone know where the "Personal.xls file" (where I save
all of my macros) is typically stored on a computer. Usually it is
hidden, but it randomly opened earlier today, and so I just closed
it.

The problem is that I don't know where to open it so that I can rehide
it and thus be able to use the macros that I have been saving on it.

Thanks for any thoughts.

Reply to this Message

Jim Chesher - 06 Feb 2008 22:45 GMT

Mine is under C:\Documents and Settings\JIM\Application
Data\Microsoft\Excel\XLSTART

> Hello - Does anyone know where the "Personal.xls file" (where I save
> all of my macros) is typically stored on a computer. Usually it is
[quoted text clipped - 5 lines]
>
> Thanks for any thoughts.

Reply to this Message

Dave K - 07 Feb 2008 15:19 GMT

> Mine is under C:\Documents and Settings\JIM\Application
> Data\Microsoft\Excel\XLSTART
[quoted text clipped - 10 lines]
>
> - Show quoted text -

Thanks to all. Apparently my company had the settings set up to hide
the Application folder that I needed to go through....

Reply to this Message

Tyro - 06 Feb 2008 22:56 GMT

Personal.xls is always in XLStart. But to hide it, just open Excel and hide
it in Excel. Then save the changes to Personal.xls. It will be hidden.

Tyro

Reply to this Message

Gord Dibben - 06 Feb 2008 23:04 GMT

Close Excel then re-open with any workbook.

Personal.xls will open. If unhidden, Windows>Hide then close Excel and answer
yes to "do you want to save etc."

But see Jim's post about where to find Personal.xls if you ever need to open it
manually.

Gord Dibben MS Excel MVP

>Hello - Does anyone know where the "Personal.xls file" (where I save
>all of my macros) is typically stored on a computer. Usually it is
[quoted text clipped - 5 lines]
>
>Thanks for any thoughts.

Reply to this Message