Personal.xlsb always locked

  • Thread starter Thread starter Compu Geek
  • Start date Start date
C

Compu Geek

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?
 
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
 
Back
Top