Excel issues accessing VBA macros and VBA modules or references

Question

Hello,We are working with several Excels files on Microsoft 365 licenses business and since a month ago we are experiencing a lot of issues when opening those files with every time a different error message.We found a temporary workaround that allow us to open and work on the files but we need to find a temporary solution.Attached is the workaround solution.Thanks for the help!&nbsp;

hansvogelaar · Answer

Lisette35F&nbsp;

Make the folder(s) containing the workbooks a trusted location for Excel. You can do this in File &gt; Options &gt; Trust Center &gt; Trust Center Settings... &gt; Trusted Locations. You may have to tick the check box "Allow Trusted Locations on my network".
In the Visual Basic Editor, select Tools &gt; References...Clear any reference whose name starts with Missing, then click OK. Save the workbook.

lisette35f · Answer

Thank you for your reply and solution HansVogelaar&nbsp;Unfortunately it doesn't work 😞We just found another easier workaround. We will try for a few days and see if that solves the issue.

Forum Discussion

Excel issues accessing VBA macros and VBA modules or references

2 Replies

Resources