PERSONAL file automatically opens upon starting Excel

  • Thread starter Thread starter Rasoul Khoshravan Azar
  • Start date Start date
R

Rasoul Khoshravan Azar

I am a newbee in writting Macros. I wrote one and now after that whenever I
start Excel, a file opens with file name: "PERSONAL".
I went to following folder: C:\Documents and Settings\TOSHIBA\Application
Data\Microsoft\Excel\XLSTART
and deleted the "PERSONAL" file. Now it is OK. But I don't know how this
file went to XLSTART folder.
Also is this deleting will affect my macros?
Is it possible to access this folder from inside Excel?
TIA Rasoul Khoshravan Azar
 
Any file in the XLSTART folder automatically opens when you start Excel.
The personal.xls workbook is the traditional name for the one we keep
the macros we use all the time - so it is useful to have it open
automatically this way. It could be called anything.
If you have deleted the workbook, you have lost your macros.

We do not need to actually see this workbook all the time, so go to the
Window menu and click 'Hide'. When Excel closes it will ask if you want
to save changes .... say Yes. To se it again, click Window menu and
'Unhide'.
 
This is the file that stores your macros. You have lost your macros. This
file is normally hidden, recreate your macros and then if you see personal
workbook , just hide it





: I am a newbee in writting Macros. I wrote one and now after that whenever I
: start Excel, a file opens with file name: "PERSONAL".
: I went to following folder: C:\Documents and Settings\TOSHIBA\Application
: Data\Microsoft\Excel\XLSTART
: and deleted the "PERSONAL" file. Now it is OK. But I don't know how this
: file went to XLSTART folder.
: Also is this deleting will affect my macros?
: Is it possible to access this folder from inside Excel?
: TIA Rasoul Khoshravan Azar
:
:
:
 
Hi Rasoul ,
If you are lucky you will find your personal.xls file in your
Recycle bin and can restore it. Hiding your personal.xls
is accomplished on your Excel window menu, hide file

Arbitrarily deleting files can get you into trouble. Much safer
is to rename or move files to another folder. All files in your
XLSTART folder are opened by Excel so renaming a file must
at least change the file extension to something that
Excel cannot recognize.

More information on macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm
http://www.mvps.org/dmcritchie/excel/install.htm

Perhaps a good time to mention backing up files
http://www.mvps.org/dmcritchie/excel/backup.htm
 
Thanks for all replies.
I was locky that my PERSONAL file exists in Recycle bin. I moved them to
another
folder.

Thanks again, Rasoul
 
Hi Rasoul,
You are very lucky indeed. Thanks for that information it
is certainly reassuring to hear that you managed to recover
your data. I suspect you've got a much better idea now
how personal.xls works. Actually your personal.xls file
does belong in your XLSTART directory, but it should be
hidden. (Excel's Window menu, hide). See getstarted.htm
and install.htm on my website as mentioned earlier in thread.

Make sure you are backing up all of your Excel files as
mentioned in http://www.mvps.org/dmcritchie/excel/backup.htm
 
Back
Top