Excel - Personal.xlsb always locked

Asked By Compu Geek on 18-Jan-10 05:54 PM
I am using Excel 2007 and have been experimenting with macros and VBA,
including the Personal.xlsb file.  Now, every time I open Excel:
1. it tells me the Personal.xlsb file is locked and do I want to read only,
be notified when its closed, or cancel
2. I cannot open Excel files from Outlook and some my previously functional
addin applications now do not work.

Now do I reset the personal.xlsb file to its original state? Is this the way
to fix the problem? If not, what is?




Gord Dibben replied to Compu Geek on 18-Jan-10 06:16 PM
That is usually caused by having one instance of Excel
running............with Personal.xlsb open and then trying to open another
workbook in a separate instance of Excel.

I would re-register Excel so's all workbooks open in a single instance.

Close Excel first and On the Windows Taskbar

1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver"(no quotes)>OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case Start>Run "C:\yourpath\excel.exe" /regserver(quotes
required)>OK.


Gord Dibben  MS Excel MVP