Personal.xlsb does not load automatically when I start Excel 2007

J

James Graham

Although my personal macro workbook (Personal.xlsb) is saved to my XLStart
folder (In Microsoft Windows XP, this workbook is saved in the C:\Documents
and Settings\user name\Application Data\Microsoft\Excel\XLStart folder).

The personal macro workbook does not open automatically when I start Excel
2007. I get the following message when I try and record a macro using the
macro recorder "Personal Macro Workbook in the startup folder must stay open
for recording".

Any suggestions how I can resolve this?

Kind Regards,
 
B

Bernie Deitrick

James,

Try moving the file out of that folder, then start Excel and record a macro into your personal macro
library. That will create a new personal.xlsb file. Then close and restart XL and see if that fixes
the problem. If it does, you can then rename the original personal.xlsb as something else, open it,
and transfer the macros to the new Personal.xlsb within the VBE...

HTH,
Bernie
MS Excel MVP
 
J

James Graham

erie,

I tried your solution but still no joy. Could this be a bug in Excel 2007?

Regards,
James
 
B

Bernie Deitrick

James,

Try re-registering Excel.

Move/delete your Personal.xlsb (depending on if it is the most recent replacement version or not...)

Close Excel if it is running.
Click Start menu > Run > type excel /unregserver, click OK.
Click Start menu > Run > type excel /regserver, click OK.

Then restart Excel, and try to record a macro into the Personal.xlsb

HTH,
Bernie
MS Excel MVP
 
J

James Graham

Bernie,

I also tried this but still no joy. I also removed and reinstalled Office
Professional 2007 but still the problem exists.

Regards,
James
 
H

Harlan Grove

James Graham said:
The personal macro workbook does not open automatically when I
start Excel 2007. I get the following message when I try and
record a macro using the macro recorder "Personal Macro Workbook
in the startup folder must stay open for recording".
Click to expand...
....

FTHOI, what are the file permissions for your Personal.xlsb file and/
or your %APPDATA%\Microsoft\Excel\XLStart folder? Can you open it
using the command formerly known as File > Open?
 
J

James Graham

Hi Harlan,

I have write permissions to Personal.xlsb and XLStart Folder (ie read only
attribute is not ticked).

Yes, I can open the Personal.xlsb using File > Open

Regards,
James
 
M

mwmadison

Although my personal macro workbook (Personal.xlsb) is saved to my XLStart
folder (In Microsoft Windows XP, this workbook is saved in the C:\Documents
and Settings\user name\Application Data\Microsoft\Excel\XLStart folder).

The personal macro workbook does not open automatically when I start Excel
2007. I get the following message when I try and record a macro using the
macro recorder "Personal Macro Workbook in the startup folder must stay open
for recording".

Any suggestions how I can resolve this?

Kind Regards,
Click to expand...

Try clocking on the Office Button at the top left of the window. Then
at the bottom of the pop-up window, under the recent documents list,
there is a button for Excel options.....click that button. Then on
the left, click on Add-in's. At the bottom of the Add-in page there
is a "Manage" drop down. Select Disabled Items from the "Manage" drop
down and hit GO. If Personal.xlsb appears there, enable it again and
it will startup when Excel starts up.

I experienced this same problem - good luck.
 
K

Ken Sadeckas

Many thanks to MWMADISO

I was going nuts trying to get my macros back and no other website had the answer but here.





mwmadiso wrote:

Re: Personal.xlsb does not load automatically when I start Excel 2007
04-Sep-07


Try clocking on the Office Button at the top left of the window. The
at the bottom of the pop-up window, under the recent documents list
there is a button for Excel options.....click that button. Then o
the left, click on Add-in's. At the bottom of the Add-in page ther
is a "Manage" drop down. Select Disabled Items from the "Manage" dro
down and hit GO. If Personal.xlsb appears there, enable it again an
it will startup when Excel starts up

I experienced this same problem - good luck.

Previous Posts In This Thread:

Personal.xlsb does not load automatically when I start Excel 2007
Although my personal macro workbook (Personal.xlsb) is saved to my XLStart
folder (In Microsoft Windows XP, this workbook is saved in the C:\Documents
and Settings\user name\Application Data\Microsoft\Excel\XLStart folder)

The personal macro workbook does not open automatically when I start Excel
2007. I get the following message when I try and record a macro using the
macro recorder "Personal Macro Workbook in the startup folder must stay open
for recording"

Any suggestions how I can resolve this

Kind Regards,

James,Try moving the file out of that folder, then start Excel and record a
James

Try moving the file out of that folder, then start Excel and record a macro into your personal macro
library. That will create a new personal.xlsb file. Then close and restart XL and see if that fixes
the problem. If it does, you can then rename the original personal.xlsb as something else, open it,
and transfer the macros to the new Personal.xlsb within the VBE..

HTH
Berni
MS Excel MV


erie,I tried your solution but still no joy. Could this be a bug in Excel 2007?
erie

I tried your solution but still no joy. Could this be a bug in Excel 2007

Regards
James

James,Try re-registering Excel.Move/delete your Personal.
James

Try re-registering Excel

Move/delete your Personal.xlsb (depending on if it is the most recent replacement version or not...

Close Excel if it is running
Click Start menu > Run > type excel /unregserver, click OK
Click Start menu > Run > type excel /regserver, click OK

Then restart Excel, and try to record a macro into the Personal.xls

HTH
Berni
MS Excel MV


Bernie,I also tried this but still no joy.
Bernie

I also tried this but still no joy. I also removed and reinstalled Offic
Professional 2007 but still the problem exists

Regards
James

Re: Personal.xlsb does not load automatically when I start Excel 2007
...
...

FTHOI, what are the file permissions for your Personal.xlsb file and
or your %APPDATA%\Microsoft\Excel\XLStart folder? Can you open i
using the command formerly known as File > Open?

Hi Harlan,I have write permissions to Personal.
Hi Harlan

I have write permissions to Personal.xlsb and XLStart Folder (ie read onl
attribute is not ticked)

Yes, I can open the Personal.xlsb using File > Ope

Regards
James

I have the same problem
I have the same problem

Re: Personal.xlsb does not load automatically when I start Excel 2007
Your problem may be due to using Excel 2007 and Excel 2003 in side-by-
side installations. See http://support.microsoft.com/kb/930480 for
work-around.

Best,
Hal

Re: Personal.xlsb does not load automatically when I start Excel 2007

Try clocking on the Office Button at the top left of the window. Then
at the bottom of the pop-up window, under the recent documents list,
there is a button for Excel options.....click that button. Then on
the left, click on Add-in's. At the bottom of the Add-in page there
is a "Manage" drop down. Select Disabled Items from the "Manage" drop
down and hit GO. If Personal.xlsb appears there, enable it again and
it will startup when Excel starts up.

I experienced this same problem - good luck.

Re: Personal.xlsb does not load automatically when I start Excel 2007
Thanks mw,

It works a treat.

Kind Regards,
James

It is indeed a very-very helpful tip. Thanks heaps.
It is indeed a very-very helpful tip. Thanks heaps.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Creating a WPF Custom Control
http://www.eggheadcafe.com/tutorial...9-c0b45fb68b78/creating-a-wpf-custom-con.aspx
 
K

Kenn Bee

Thank you very much for your help. I would guess that you knew that you helped out the poster of the message... but you have helped a stranger, who you don't even know... over two years AFTER helping the original recipient of your advice. It worked perfectly for me, and saved quite a few macros that took WELL over 40 hours to make! (OK... took me 10 hours to make... but 30 hours to make work properly!)

Thank you once again, mwmadiso!
 
V

vampandmafia

Try clocking on the Office Button at the top left of the window. Then
at the bottom of the pop-up window, under the recent documents list,
there is a button for Excel options.....click that button. Then on
the left, click on Add-in's. At the bottom of the Add-in page there
is a "Manage" drop down. Select Disabled Items from the "Manage" drop
down and hit GO. If Personal.xlsb appears there, enable it again and
it will startup when Excel starts up.

I experienced this same problem - good luck.
Click to expand...

Excellent! I would NEVER have found that - fixed it a treat!
 

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 comes up by default launching Excel 2007 1
PERSONAL.xlsb locked for editing?? 3
Excel 2010 Negative Number in Parentheses 1
PERSONAL.XLSB 8
personal.xlsb 2
Personal.xlsb in Excel 2007 stopped being open at start 3
No New Workbook Annoyance 2
removing personal.xlsb file 2

Top