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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

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,113,823
Messages
5,544,538
Members
410,619
Latest member
gregor222
Top