Personal.xlsb always locked
 

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 can't open Excel files from Outlook and some my previously functional
addin applications now don't 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?

Personal.xlsb always locked
 

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) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "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 StartRun "C:\yourpath\excel.exe" /regserver(quotes
required)OK.


Gord Dibben MS Excel MVP

On Mon, 18 Jan 2010 14:54:01 -0800, Compu Geek
wrote:

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 can't open Excel files from Outlook and some my previously functional
addin applications now don't 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?