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

Asked By James Graham on 01-Aug-07 09:01 AM
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,




Bernie Deitrick replied on 01-Aug-07 11:45 AM
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
James Graham replied on 01-Aug-07 03:44 PM
erie,

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

Regards,
James
Bernie Deitrick replied on 02-Aug-07 12:22 PM
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
James Graham replied on 02-Aug-07 03:35 PM
Bernie,

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

Regards,
James
Harlan Grove replied on 02-Aug-07 04:54 PM
...
...

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?
James Graham replied on 03-Aug-07 03:08 PM
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
antonio.mannell replied on 19-Aug-07 04:52 AM
I have the same problem
hal.easo replied on 26-Aug-07 05:59 PM
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
mwmadiso replied on 04-Sep-07 12:23 AM
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.
James Graham replied on 10-Sep-07 04:17 AM
Thanks mw,

It works a treat.

Kind Regards,
James
Rajat N Vyas replied on 25-Feb-09 02:21 AM
It is indeed a very-very helpful tip. Thanks heaps.
Ken Sadeckas replied to mwmadiso on 27-Feb-10 07:40 PM
Many thanks to MWMADISO



I was going nuts trying to get my macros back and no other website had the answer but here.
Kenn Bee replied to mwmadiso on 25-Oct-10 07:11 PM
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 E replied to mwmadiso on 09-May-11 12:49 PM
I had the same problem using Excel 2007 (5/9/2011) and this fix worked perfectly. Very clear explanation, thank you so much!! This was the only solution I could find on the web that worked properly and specifically for Excel 2007.