PERSONAL.XLSB is locked for editing by enduser

csenor

Board Regular
Joined
Apr 10, 2013
Messages
159
Office Version
  1. 365
Platform
  1. Windows
How do I get this message from popping up every time I open an excel file even if it doesn't have a macro built in? No other file is open on the computer. I have removed all VBA code form the personal macro workbook, but it didn't change anything. I tried to save the personal macro workbook, but it says it's read only. I checked the properties tab of personal.xlsb and saw that the file was not in read only status.

Windows 10 machine
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,871
Office Version
  1. 365
Platform
  1. Windows
Delete it
- not required unless being used
- easy to make a new copy when required

File path - try amending the name and look here
C:\Users\??csenor??\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB
 

Watch MrExcel Video

Forum statistics

Threads
1,114,065
Messages
5,545,788
Members
410,706
Latest member
antstt
Top