Share via

Using macros for a solidworks excel design table is consistently blocked despite many attempts to unblock it

David C 0 Reputation points
2025-12-05T18:56:16.18+00:00

Every time I open the design table, I am met with this warning. I have found a book1 file and allowed it within trust settings yet still have not been met with any success. Similarly, I changed a lot of other trust center settings in an attempt to permit this file to be used but have not been met with any success.

The document is internal, so it is trustworthy, but it is also unclear whether or not the book1 that I found is the one actually being referenced, since previous attempts did not make the error go away. I made a separate table with similar functionality in an attempt to not have a spreadsheet with the same reference but saw the same warning as before once I added macros. Capture

Microsoft 365 and Office | Excel | For business | Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Hendrix-C 8,565 Reputation points Microsoft External Staff Moderator
    2025-12-05T20:23:17.2666667+00:00

    Hi @David C,

    Thank you for posting your question in the Microsoft Q&A forum.

    According to your concern, I suggest you checking this guideline to see if it helps resolve the issue. You can skip any steps that you've tried but had no positive results:

    1- Remove the Mark of the Web (MOTW)  

    • Open File Explorer, navigate to your Excel file that having error
    • Right click on it and choose Properties 
    • In General tab, check the Unblock box for the Security option. 

    User's image

    • If the Unblock options is not available, it's usually because that your file is currently saved in a OneDrive or SharePoint folder and it will be considered as from the internet.
    • You can try disconnecting OneDrive/SharePoint temporarily or move the file to your local folder and try the Unblock Security box again.

    2- Double check the Trust Locations settings

    • Open Excel and go to File > Options > Trust Center > Trust Center Settings
    • Select Trusted Locations in the left bane > check in the list if your file path has been added in there.
    • If not, press Add new location > Browse and navigate to the folder where you keep the files
    • Press OK to close all the dialog boxes then try opening your excel file again 

    3- Enable macros in Excel 

    • Go to File > Options > Trust Center > Trust Center Settings 
    • Click Macro Settings and choose "Enable VBA macros" (since you're sure the file is safe) 
    • Then click OK to save the settings

    4- Disable Protected view

    • Go to File > options > Trust center > Trust center settings
    • Choose Protected view and uncheck all the options

    User's image

    Please understand that our initial response does not always resolve the issue immediately. However, you can try these steps and let me know if it works for you. If not, we can work together to resolve this.    

    Thank you for your patience and your understanding. If you have any questions or need further assistance, please feel free to share them in the comments so I can continue to support you. 

    I look forward to your response.

    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. 

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.