Type mismatch for Visual Basic after Office 365 update in May 31 and June 3

Anonymous
2024-06-05T08:13:50+00:00

Hi, after updates Office 365 from Microsoft my file with Visual Basic stops working.

There is issue:

in Office 2019 the file works without any problem, I have checked the settings for the macro in Trust Center, I have set it up similarly but it does not do anything.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2024-07-16T07:09:46+00:00

The problem was resolved during the next Office update.

Version 2406 (17726.20126) no longer contains this bug.

Was this answer helpful?

0 comments No comments

6 additional answers

Sort by: Most helpful
  1. Anonymous
    2024-06-05T09:33:14+00:00

    Yes, I am aware of this documentation.

    The files were working before the Office 365 update.

    Can we do some online diagnostics via Teams?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-06-05T09:26:42+00:00

    You can check possible cause in this link.

    Type mismatch (Error 13) | Microsoft Learn

    Make a copy of that file , remove all the sensitive information in it. Share a file which can reproduce your issue.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2024-06-05T09:04:14+00:00

    file is confidential, please indicate how we can collect data from the error handling

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2024-06-05T08:53:57+00:00

    Could you share a test file to reproduce your issue?

    For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

    Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

    Was this answer helpful?

    0 comments No comments