Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Still the same error.
Microsoft Excel Visual Basic Error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I am running Windows 10. I have Office 365 ProPlus with 2013 apps installed on my laptop.
A few months ago, Excel started opening up a "PERSONAL.XLSB" file every time I opened the program. It didn't happen before. Looking online, one solution was to hide the file. I did this by creating an "Archive" subfolder in the ...\AppData\Roaming\Microsoft\Excel\XLSTART folder that the personal.xlsb file was saved in and stashing the file into the "Archive" subfolder.
Around the same time, the following error started to pop up when I open up Excel:
The error doesn't come up everytime. It seems to come up every other time I open Excel. I know all is not right with the software because when I close the program, the program flickers through another window. Otherwise, Excel seems to run fine for what I use it for (minor spreadsheet work).
I'm not sure if this issue is related to the PERSONAL.XLSB file issue or not, but I wanted to bring this up to provide as much information as possible.
I have gone twice through the following complete cycle: uninstalled Microsoft Office, shut down the computer, and reinstalled Microsoft Office. The error has not gone away.
Can someone help me get rid of this error every time I open Excel?
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
{count} votes
7 answers
Sort by: Most helpful
-
Anonymous
2016-02-25T08:53:10+00:00 -
Anonymous
2016-02-25T10:24:15+00:00 It's probably a problem with the code in one of the three add-ins that you have (Solver, TreePlan, Funcres).
Disable all three (File -> Options -> Add-Ins. Select Excel Add-ins in the Manage-box (bottom of the dialogue) and click Go. Uncheck the Add-ins.
Close Excel and re-open it. Does the problem persist? If no, then select/check the add-ins one by one, closing and re-opening Excel each time to see which Add-ins causes the problem.