Prev: Autofilter Array
Next: Using Excel GoalSeek on Access form
From: Compu Geek on 18 Jan 2010 17:54
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?

From: Gord Dibben on 18 Jan 2010 18:16
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

On Mon, 18 Jan 2010 14:54:01 -0800, Compu Geek
<CompuGeek(a)discussions.microsoft.com> 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?

 | 
Pages: 1
Prev: Autofilter Array
Next: Using Excel GoalSeek on Access form