Home

PERSONAL.XLSB -> Excel only reads file every second start

%3CLINGO-SUB%20id%3D%22lingo-sub-124523%22%20slang%3D%22en-US%22%3EPERSONAL.XLSB%20-%26gt%3B%20Excel%20only%20reads%20file%20every%20second%20start%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-124523%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20using%20a%20new%20PC%20running%20Win%2010%2064bit%20and%20MS%20Office%20Professional%20Plus%202016%20(Excel%2032bit).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20copied%20the%20PERSONAL.XLSB%20file%20from%20old%20PC%20to%20new%20into%20the%20XLSTART%20folder%20accordingly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStarting%20Excel%20after%20fresh%20restart%20of%20the%20PC%2C%20it%20opens%20the%20PERSONAL.XLSB%20file%20and%20all%20macros%20are%20available%20(splash%20screen%20is%20shown).%20Closing%20Excel%20and%20doing%20a%20second%20start%20of%20Excel%20won't%20open%20that%20file%20and%20macros%20are%20not%20available%20(no%20splash%20screen%20at%20start).%20Closing%20it%20again%20and%20opening%20it%20the%20third%20time%2C%20everything%20is%20fine%20again%20(splash%20screen)%2C%20next%20time%20it%20does%20not%20show%20any%20macros%20(and%20no%20splash%20screen)%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI.e.%20every%20second%20start%20the%20macros%20of%20the%20PERSONAL.XLSB%20file%20are%20not%20available%20(and%20no%20splash%20screen%20is%20shown)%2C%20which%20is%20really%20annoying%2C%20as%20I%20need%20the%20macros%20often%20and%20need%20to%20close%20Excel%20and%20start%20it%20again%20to%20get%20working%20with%20my%20macros.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20figured%20out%2C%20that%20after%20first%20run%20Excel%20does%20not%20close%20completely.%20There%20is%20still%20a%20process%20visible%20in%20the%20task%20manager.%20It%20is%20gone%20after%20closing%20the%20second%20time%20(when%20no%20macros%20are%20available).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20remove%20the%20PERSONAL.XLSB%20file%20from%20XLSTART%20Excel%20behaves%20as%20I%20would%20expect%20it%20to%20do.%20Closes%20always%20completely%20and%20no%20process%20is%20left%2C%20i.e.%20every%20start%20a%20fresh%20start%20(which%20can%20be%20seen%20as%20the%20splash%20screen%20appears%20at%20start-up).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20try%20was%20to%20show%20the%20PERSONAL.XLSB%20and%20close%20this%20instance%20before%20closing%20the%20other%20workbooks%20in%20Excel.%20In%20this%20case%2C%20Excel%20closes%20completely%20and%20another%20start%20leads%20to%20a%20fresh%20start%20including%20splash%20screen%20and%20available%20macros.%20As%20soon%20as%20I%20hide%20the%20PERSONAL.XLSB%20and%20close%20Excel%2C%20it%20will%20behave%20as%20described%20above.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20independant%20of%20starting%20Excel%20out%20of%20Start%20-%26gt%3B%20All%20Apps%20or%20by%20double%20click%26nbsp%3Ban%20file%20with%20an%20extension%2C%20which%20is%20linked%20to%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20my%20old%20PC%20did%20not%20showed%20that%20behaviour%20I%20would%20be%20pleased%20to%20find%20the%20setting%20to%20cure%20this%20issue%20and%20get%20rid%20of%20two%20times%20Excel%20starts%20to%20use%20the%20macros%20accordingly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20support.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJoe%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-124523%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20%26amp%3B%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Estart%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

Hi,

I'm using a new PC running Win 10 64bit and MS Office Professional Plus 2016 (Excel 32bit).

 

I've copied the PERSONAL.XLSB file from old PC to new into the XLSTART folder accordingly.

 

Starting Excel after fresh restart of the PC, it opens the PERSONAL.XLSB file and all macros are available (splash screen is shown). Closing Excel and doing a second start of Excel won't open that file and macros are not available (no splash screen at start). Closing it again and opening it the third time, everything is fine again (splash screen), next time it does not show any macros (and no splash screen) etc.

 

I.e. every second start the macros of the PERSONAL.XLSB file are not available (and no splash screen is shown), which is really annoying, as I need the macros often and need to close Excel and start it again to get working with my macros.

 

I've figured out, that after first run Excel does not close completely. There is still a process visible in the task manager. It is gone after closing the second time (when no macros are available).

 

If I remove the PERSONAL.XLSB file from XLSTART Excel behaves as I would expect it to do. Closes always completely and no process is left, i.e. every start a fresh start (which can be seen as the splash screen appears at start-up).

 

Another try was to show the PERSONAL.XLSB and close this instance before closing the other workbooks in Excel. In this case, Excel closes completely and another start leads to a fresh start including splash screen and available macros. As soon as I hide the PERSONAL.XLSB and close Excel, it will behave as described above.

 

This is independant of starting Excel out of Start -> All Apps or by double click an file with an extension, which is linked to Excel.

 

As my old PC did not showed that behaviour I would be pleased to find the setting to cure this issue and get rid of two times Excel starts to use the macros accordingly.

 

Thanks for your support.

 

Joe