New Download of office365 gives error message when opening a file

Alan Rahimi 0 Reputation points
2023-06-01T16:02:52.73+00:00

I have downloaded office 365 suite on my MAC computer. When opening or creating a new file, it gives me an error message Titled Visual Basic Applications and down below it says Run-time error '53'. The options to respond are Help or End button. How could this go away and not show up every time?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,669 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. AllenXu-MSFT 18,041 Reputation points Microsoft Vendor
    2023-06-02T05:56:44.0866667+00:00

    Hi @Alan Rahimi,

    May I know on which office application this error occurs, word, Excel or others?

    Firstly, if this issue happens when creating or opening Word file, please try these steps to get rid of the error message:

    1. Close all Office applications
    2. Go to /Users/your-user-name-here/Library/Group Containers/UBF8T346G9.Office/User Content/Startup/Word
    • If the Library folder is initially hidden, press the “Command” + “Shift” + “.” (period) keys at the same time to display it.
    1. Remove linkCreation.dotm
    2. Restart Word.

    To fix this error for other office applications for example PowerPoint and Excel, you need to:

    1. Remove the SaveAsAdobePDF.ppam and SaveAsAdobePDF.xlam from the PowerPoint and Excel folders next to the Word folder.
    2. Launch Excel and PowerPoint and go to the menu Tools -> Excel Add-ins... and Tools -> PowerPoint Add-ins..., respectively, and remove the Save as Adobe PDF add-in, by unckecking it and removing it with the "-" button and then click OK.
    3. Restart Excel and PowerPoint and the problem should go away. If not, try several times to remove those options from the Tools menu until the problem goes away. I had to repeat this procedure in PowerPoint until this got fixed.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Tanay Prasad 2,115 Reputation points
    2023-06-02T06:00:58.3833333+00:00

    Hi,

    I assume this is occurring in your excel application.

    The "Run-time error '53'" in VBA indicates that a specific file or reference required by your VBA code is missing. This error typically occurs when the code tries to reference a file that is not present or cannot be found.

    You can try the following steps:

    1. Check file references: Review your VBA code and ensure that all file references are correct. Verify that the file path specified in the code matches the actual location of the file on your computer. If any references are incorrect or missing, update them accordingly.
    2. Repair Office installation: It's possible that the error is caused by a corrupted or incomplete Office installation. Try repairing your Office 365 suite installation.
    3. Disable third-party add-ins: Some third-party add-ins or plugins installed on your computer might conflict with Office applications and trigger the error message. Try disabling any third-party add-ins and check if the error still occurs. You can disable add-ins through the "Preferences" or "Options" menu in each Office application.

    Trying referring to this link once as well- https://learn.microsoft.com/en-us/answers/questions/1007772/run-time-error-53

    It is also possible that your Excel file is corrupted and in that case, you'll have to repair excel file.

    Best Regards.

    0 comments No comments