Personal.xlsb always locked

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PERSONAL.XLSB 8
How to apply a macro to all workbooks 2
Personal.xlsb in Excel 2007 stopped being open at start 3
Personal.xlsb counts as a workbook, can I "super" hide it? 6
trying to replace auto_open with something like workbook_open 1
Giving back 2
Excel Personal.xlsb file shows up all the time with new spreadsheets 1
removing personal.xlsb file 2

Top