Excel Alert: Can't find Personal Macro Workbook

[richtoker]

Every since updating to Excel for Mac Version 16.18 (181014) recently, everytime I open Excel I receive an Alert saying "Sorry, we couldn't find Personal Macro Workbook. Is it possible it was moved, renamed or deleted?"
I haven't moved, renamed or deleted it it. It has been in the same folder for years. Any suggestions?

 

[MARK858]

Try putting it in the location below and see if it makes a difference.

~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/User/

 

[richtoker]

Try putting it in the location below and see if it makes a difference.

Thanks for your suggestion. That is exactly where the file is and always has been. But Excel must be looking somewhere else since the update.

 

[MARK858]

You could try....

~/Library/ Group Containers/UBF8T346G9.Office/User Content/Startup/Excel

 

[richtoker]

You could try....

That didn't do it either. That folder contains PERSONAL.XLSB. I tried moving the Personal Macro Workbook there but it didn't make a difference.

Thanks.

 

[zbert]

Every since updating to Excel for Mac Version 16.18 (181014) recently, everytime I open Excel I receive an Alert saying "Sorry, we couldn't find Personal Macro Workbook. Is it possible it was moved, renamed or deleted?"
I haven't moved, renamed or deleted it it. It has been in the same folder for years. Any suggestions?

I am having this exact same problem. It is like Excel is pointing somewhere other than where the PERSONAL.XLSB file is located. If you have figured this out, please let me know.

--zbert