Personal.xls locked for editing

[wayne]

Hi
I get "Personal.xls locked for editing by '.' " for users
opening Excel. Can anyone advise where this file is and
who could have it locked ?
thanks
Wayne

 

[Dave Peterson]

It should be in your XLStart folder (use windows|find/search to look for it).

And maybe it's this (from Debra Dalgleish's site):
http://www.contextures.com/xlfaqApp.html#ReadOnly
or
http://www.contextures.com/xlfaqApp.html#AlreadyOpen

 

[Gord Dibben]

Wayne

One possible cause.......

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

 

[wayne]

Thanks - the files are on a Terminal Server, I will clear
out temp files and reboot tonite. Should all users have
full access to the personal.xls file ?

thanks Wayne

-----Original Message-----
It should be in your XLStart folder (use

windows|find/search to look for it).

 

[Dave Peterson]

I'm not sure how Terminal Servers work. But on pc's, each user who can logon
gets their own (if they have one).

And they don't have to be the same file.