Home

Personal.xlsb Workbook Keeps Opening

%3CLINGO-SUB%20id%3D%22lingo-sub-163210%22%20slang%3D%22en-US%22%3EPersonal.xlsb%20Workbook%20Keeps%20Opening%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-163210%22%20slang%3D%22en-US%22%3E%3CP%3EEvery%20time%20I%20open%20Excel%2C%20the%20Personal.xlsb%20workbook%20opens.%26nbsp%3B%20It%20did%20not%20used%20to%20do%20that.%26nbsp%3B%20Anyone%20know%20how%20I%20can%20prevent%20it%20from%20opening%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDon%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-163210%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-308359%22%20slang%3D%22en-US%22%3ERe%3A%20Personal.xlsb%20Workbook%20Keeps%20Opening%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-308359%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Adam%2C%20I%20am%20getting%20this%2C%20and%20I%20agree%20its%20very%20frustrating.%26nbsp%3B%20Did%20you%20manage%20to%20get%20a%20fix%3F%3C%2FP%3E%3CP%3Efor%20me%20its%20when%20I%20open%20an%20excel%20file%20from%20different%20locations%20ie%20oneDrive%2C%20SharePoint%2C%20local%20drive%20etc%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-289451%22%20slang%3D%22en-US%22%3ERe%3A%20Personal.xlsb%20Workbook%20Keeps%20Opening%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-289451%22%20slang%3D%22en-US%22%3EQuick%20and%20easy%2C%20thank%20you.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-193303%22%20slang%3D%22en-US%22%3ERe%3A%20Personal.xlsb%20Workbook%20Keeps%20Opening%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193303%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20suffering%20the%20same%20thing.%26nbsp%3B%20Since%20Excel%20opens%20a%20new%20instance%20each%20time%2C%20and%20not%20just%20a%20new%20book%2C%20it's%20also%20opening%20the%20personal%26nbsp%3Bmacro%20workbook%2C%20saying%20it's%20already%20in%20use%20and%20if%20I%20want%20to%20open%20it%20as%20read%20only%20or%20be%20notified%20when%20it%20is%20available.%3C%2FP%3E%3CP%3EThis%20is%20extremely%20tiresome%20as%20I%20use%20macros%20and%20multiple%20files%20a%20lot.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-163259%22%20slang%3D%22en-US%22%3ERe%3A%20Personal.xlsb%20Workbook%20Keeps%20Opening%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-163259%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Don%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20you%20open%20Excel%20select%20the%20%3CSTRONG%3EPersonal%20Macro%20Workbook%20%3C%2FSTRONG%3Eand%20go%20to%3A%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EView%3C%2FSTRONG%3E%26gt%3B%26gt%3B%20%3CSTRONG%3EWindow%3C%2FSTRONG%3E%26gt%3B%26gt%3B%20%3CSTRONG%3EHide%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EAfter%20that%2C%20close%20Excel%2C%20and%20you%20will%20face%20a%20message%20asking%20you%20to%20save%20the%20changes%20you%20made%20to%20the%20Personal%20Macro%20Workbook%2C%20click%20%3CSTRONG%3ESave%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Every time I open Excel, the Personal.xlsb workbook opens.  It did not used to do that.  Anyone know how I can prevent it from opening?

 

Don

4 Replies
Highlighted

Hi Don,

 

When you open Excel select the Personal Macro Workbook and go to:

View >> Window >> Hide

After that, close Excel, and you will face a message asking you to save the changes you made to the Personal Macro Workbook, click Save.

I am suffering the same thing.  Since Excel opens a new instance each time, and not just a new book, it's also opening the personal macro workbook, saying it's already in use and if I want to open it as read only or be notified when it is available.

This is extremely tiresome as I use macros and multiple files a lot. 

Quick and easy, thank you.

Hi Adam, I am getting this, and I agree its very frustrating.  Did you manage to get a fix?

for me its when I open an excel file from different locations ie oneDrive, SharePoint, local drive etc