Personal Macro File Disappears (Excel 2010) Solved

Question

Hello,

I created several macros that I put in a personal macro file.
There are 5 of us doing the same work. So I sent them my file for them to save it on their workstation.
I helped them install it and assign a quick access key to their quick access toolbar (6 keys).
After installation, I tested each key and everything works fine.

The problem is that at some point, I don't know why, the keys stop working. But they can still activate the macros by manually going to View Macros / Run.

And this morning, poof, the file disappeared.

Why does it disappear like that?

On my machine, it never does that. And I saved the file for them in the same place mine is, which is on the C drive (a few folders down).

Sometimes, I do updates and I want to send them a new one, but I need to fix this problem first.

We had to go back to the C drive and reopen the file.

Thank you.

Configuration: Windows 7 / Internet Explorer 8.0

El-sol · Accepted Answer

I FOUND IT !!!!!

After searching through all the forums on the internet, where someone else might have encountered the same problem, someone provided this solution:

Go to "Excel Options" / "Add-Ins" menu
At the bottom right of the Manage drop-down list.
Choose "Disabled Items" > Click on the "Go..." button
Select PERSONAL.XLSB and click the "Activate" button

IT WORKS!!!! Finally.
Phew, my colleague is very happy now.

So I'm sharing the solution with you.

Have a good day everyone, it's ending my week well, it :)

acropolo · Answer

Have you checked the settings of the control buttons?
I'm not very good in this area, but it's often just silly mistakes
Wrong manipulation / misconfiguration / computer bug / accidental or intentional deletion of the folder...

Best regards

El-sol · Answer

What do you mean by button settings?

However, I just saw something interesting that could give us a lead.

When I hover my cursor over one of the buttons (on my workstation), it says:
PERSONAL.XLSB!caissepop

and on someone else's, it says:
caissepop

as if the link between the shortcut and the file is lost or as if the file is not recognized as a personal macro file.

Here is the message that appears when attempting to execute it with the button:

Unable to run the macro ""C:\Users\Sylvie\AppData\Local\Microsoft\Temporary Internet Files\Content.Outlook\VH5KTSLX\PERSONAL.XLSB'!caissepop". It may not be available in this workbook or all macros may be disabled.

And the file must be on
C:\Users\Sylvie\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL

And I had created a shortcut on my desktop for quicker access when I want to update.
Is it because of the shortcut?

eriiic · Answer

Hello,

Unable to run the macro "C:\Users\Sylvie\AppData\Local\Microsoft\Temporary Internet Files\Content.Outlook\VH5KTSLX\PERSONAL.XLSB'!caissepop'. It may not be available in this workbook or all macros may be disabled.

And the file must be on
C:\Users\Sylvie\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL
It must have been saved after opening on the intranet or from the email.
Save it in xlstart.

eric

--
Never will you respond to an unsolicited DM...
Well, that’s done.

El-sol · Answer

I went back to see if the file was in its place.
It was there.
I reactivated the file, destroyed the shortcut buttons because they seemed linked to a temporary file, deleted the desktop shortcut, recreated the shortcut buttons, closed and reopened Excel.
If I go to View / Show Macros, I don't see the file. (On my workstation, I still see it, even if it's a hidden file.)

Then, I opened a file, clicked on one of the buttons, and the macro works. I go back to View / Show Macros, and all the macros are visible.
Weird, isn't it? It seems like you need to use one of the buttons for the file to show up in "show macros."
In any case, for now, the macros are working. We'll see when she closes her laptop to take it home on Friday (she works from home on Fridays) and we'll see on Monday if the personal macro file hasn't "moved" during transport :)

To be continued...

Thank you

El-sol · Answer

On the other hand, for another employee, it's worse.
The file is in the right place, the shortcut buttons are linked to the correct file but refuse to work.
When we close and reopen Excel, the personal file disappears.
I have to go through the whole process to reactivate it and I have to manually execute each macro because the buttons refuse to work.
When I hover the cursor over one of the buttons, I still see:
PERSONAL.XLSB!caissepop
So why does it refuse to work?
Why is it different from one workstation to another?

El-sol · Answer

I'm reiterating my question because I haven't found an answer yet.
Especially regarding my previous message. For the second-to-last message, the one with a mobile phone, it still works very well.
But for the other one, the file is still in the correct location in XLSTART. If I open it to activate it, it appears in their Excel. But as soon as we close Excel and it asks if we want to save changes to the personal macro workbook, I say yes. And when we reopen Excel, the file is no longer there in "view macros."
Is there something in the settings of their Excel or their computer that might be different from mine?

El-sol · Answer

I’m starting to think it’s a bug in Excel 2010; there’s Al'x who has the same problem as me and just posted his question.

El-sol · Answer

Alright, thank you.

Personal Macro File Disappears (Excel 2010)

9 answers

Aoemi backupper

Texture issues in enshrouded

Hevc h.265 video player

Unwanted number

Excel fields

Record your game and film yourself at the same time

Buying a samsung smartphone

Mobile data impossible

Home screen display

How to free up space on the c drive