Problem with personal.xlsb

%3CLINGO-SUB%20id%3D%22lingo-sub-921364%22%20slang%3D%22en-US%22%3EProblem%20with%20personal.xlsb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-921364%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3ERecently%20I%20updated%20my%20computer.%20Then%2C%20it%20became%20slower%20to%20open%20files%2C%20documents..%20But%20my%20biggest%20problem%20is%20that%20every%20Excel%20file%20I%20have%20is%20opened%20as%20Read%20Mode%20only%2C%20even%20the%20new%20ones%20can%E2%80%99t%20be%20modified.%3CBR%20%2F%3EThat%20because%20when%20I%20open%20Excel%2C%20a%20message%20says%20more%20or%20less%20%3A%20%C2%AB%26nbsp%3B%20PERSONAL.XLSB%20is%20locked%2C%20your%20document%20is%20in%20Read%20Mode%26nbsp%3B%C2%BB%20(sorry%20for%20the%20bad%20translation%20from%20French).%3CBR%20%2F%3EAnyway%2C%20I%20can%E2%80%99t%20work%20and%20can%E2%80%99t%20find%20C%3A%2FUsers%2FProfil%20etc...%20where%20the%20VBA%20files%20that%20doesn%E2%80%99t%20work%20is%20sais%20to%20be..%20Can%20toi%20help%20me%3F%20I%20am%20on%20an%20intership%20where%20I%20really%20need%20Excel%20to%20work%20on%20big%20data%20bases%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-921364%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-944402%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20personal.xlsb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-944402%22%20slang%3D%22en-US%22%3Epersonal.xlsb%20can%20be%20found%20by%20typing%20this%20in%20Windows%20Explorer's%20address%20bar%20and%20hitting%20enter%3A%3CBR%20%2F%3E%25appdata%25%5Cmicrosoft%5Cexcel%5Cxlstart%3CBR%20%2F%3EI%20would%20first%20try%20to%20restart%20your%20computer%2C%20maybe%20a%20(hidden)%20instance%20of%20Excel%20is%20still%20open.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-944648%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20personal.xlsb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-944648%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F429936%22%20target%3D%22_blank%22%3E%40Aline1908%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGive%20this%20a%20try%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Feasyboard.org%2F2017%2F01%2F12%2Fpersonal-xlsb-is-locked-for-editing%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Feasyboard.org%2F2017%2F01%2F12%2Fpersonal-xlsb-is-locked-for-editing%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
Hi,

Recently I updated my computer. Then, it became slower to open files, documents.. But my biggest problem is that every Excel file I have is opened as Read Mode only, even the new ones can’t be modified.
That because when I open Excel, a message says more or less : «  PERSONAL.XLSB is locked, your document is in Read Mode » (sorry for the bad translation from French).
Anyway, I can’t work and can’t find C:/Users/Profil etc... where the VBA files that doesn’t work is sais to be.. Can toi help me? I am on an intership where I really need Excel to work on big data bases
2 Replies
Highlighted
personal.xlsb can be found by typing this in Windows Explorer's address bar and hitting enter:
%appdata%\microsoft\excel\xlstart
I would first try to restart your computer, maybe a (hidden) instance of Excel is still open.
Highlighted