O365 update disabled macros

User avatar
Leif
Administrator
Posts: 7208
Joined: 15 Jan 2010, 22:52
Location: Middle of England

O365 update disabled macros

Post by Leif »

I have just had an update run on my Office 365 and found that no Excel macros would run.

After a bit of digging, I discovered that my personal.xlsb had been disabled.

Resolution:
File > Options > Addins...
At the bottom of that window is a 'Manage:' dropdown - select Disabled Items and the click Go...
x.jpg
Select Personal.xlsb and then 'Enable'

I have no idea why this should happen, but hopefully the above may help others.
(Current Excel version is now 2302 (Build 16130.20332 Click-to-Run)
You do not have the required permissions to view the files attached to this post.
Leif

User avatar
HansV
Administrator
Posts: 78402
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: O365 update disabled macros

Post by HansV »

Thanks!

Microsoft appears to have trouble with their Office updates recently. Today is the second time in the last two weeks or so that the 2303 version has been rolled back to 2302.
Best wishes,
Hans