Personal.xlsb file not loading while Starting Excel

[chrisham7276]

Hi,

I am a power excel user, but on of my PC, my Personal.xlsb file does not load, and my attempts to start a macro recording to initiate this, too fails. I get a message preventing me to begin the macro recording.
Any hel will be highly appreciated.

Chrisham

 

[Richard Schollar]

Hi & Welcome to the Board!

If you go Office button>Excel Options>Add-Ins and look thru the list of add-ins there is a Disabled Items section at the bottom. Is your Personal.xlsb listed there? If so, you can reenable by using the Manage dropdown on the same page.

 

[chrisham7276]

Richard,
Thanks for your response. Currently I am working on my office PC that is working fine, in that I am able to access the Personal Macro. But following the procedure outlined by you, I do see a mention of the Personal.xlsb file in the active section of the Add-in areas. (And neither is it there in the inactive section.
I am following your procedure correctly? Or is it some different solution to it here?

BTW, what is the board html maker?

Chrisham

 

[Richard Schollar]

If you click on the Manage dropdown and select Disabled Items and then Go, do you see anything listed there?

The board html maker is an Excel add-in that can be used to generate html to display your Excel data in a message. If you want to try it out, please drop me your email address in a PM

 

[riaz]

Hi all

I am getting the same problem, but with different circumstances. I have installed 2007 side by side with 2002 (yes, I know, I am a dinosaur).

I was converting a file from 2003 to 2007. I saved the file in 2007 format, then opened the new file in 2007 and on another screen opened the old file in 2002.

Since then, if I open one instance of 2007, I get the "corrupt xlsb" message. If I open two instances of Excel 2007, it tells me (like 2002 used to tell me) that personal.xls is locked and can only be opened as read-only.

It seems that 2007 has decided that the old personal.xls is valid and the new one is corrupt. I don't mind which it uses, but the message is annoying, not only for the niggle factor, but also for not knowing why it is behaving like this.

Any thoughts?

I suppose I could delete the .xlsb file, create a new one, copy all my fiddly bits out of the old personal to the new one, but I would like to know why before I do the fix.

 

[RoryA]

Do you have both workbooks in the same XLSTART directory?

 

[riaz]

Hi Rory

They've both ended up in the same XLSTART folder. I suppose I should move the old one and point the old excel to the new location (only because I haven't figured out how to point in the new excel)

Still, not doing anything until you give permission

(2007 for 3 days and counting)

 

[RoryA]

I would put them in separate folders (if you use the XLSTART folders in the Office directory under Program Files, there should be a separate folder for each version) and see what happens. If the .xlsb is still corrupt, then create a new one.

 

[riaz]

Thanks Rory. They are both currently in C.\Documents and Settings\riazh\application data\Microsoft\Excel.

Will move them on Monday. I need a weekend to recover from this conundrum first.

Have a good weekend.
Riaz

 

[RoryA]

You too!
The joys of running 2007 with earlier versions are many and varied...