Personal.xls
 

I have a Personal.xls workbook in my C:\Documents and Settings\Application
Data\Microsoft\Excel\XLSTART area. In this workbook I have some macros that
I would like to be accessible whenever I use Excel.

Over the past couple of days I've developed a problem where all of the
spreadsheets I open show that 'Personal.xls is locked for editing by 'ME!'.
This is affecting linking and auto transfering of data. I've gone to my
Personal.xls file, and when I attempt to open it directly... it again show
that I'm locking it.

How can I correct this problem?

Cathy

Excel stores in Windows\Temp(win98) folder a copy(s) of any file that is open.

Sometimes this *.tmp file is not deleted from the Temp folder when you close
out Excel(maybe a crash of Excel?) or the file, so Excel thinks it is still
open and locked for editing.

You can try a re-boot and see if that clears it up. If not, after a re-boot,
clear out your Windows\Temp folder.

If using WinXP your Temp folder would be under user.......

Documents and Settings\User\Local Settings\Temp

If on a network, re-booting the server may be the only solution.


Gord Dibben Excel MVP

On Thu, 27 Jan 2005 14:23:01 -0800, "Cathy"
wrote:

I have a Personal.xls workbook in my C:\Documents and Settings\Application
Data\Microsoft\Excel\XLSTART area. In this workbook I have some macros that
I would like to be accessible whenever I use Excel.

Over the past couple of days I've developed a problem where all of the
spreadsheets I open show that 'Personal.xls is locked for editing by 'ME!'.
This is affecting linking and auto transfering of data. I've gone to my
Personal.xls file, and when I attempt to open it directly... it again show
that I'm locking it.

How can I correct this problem?