How do I force MS Office to trust a file?


  1. Posts : 15
    Version 21H2 (OS Build 22000.1455)
       #1

    How do I force MS Office to trust a file?


    I am trying to add xl2bb.xlam from another forum so that I am able to add a mini spreadsheet to my posts about Excel.

    The version of Excel I am using is MSOffice Pro Plus 2021 version 2302 (Build 16130.20332) as of 27MAR2023.

    Windows Build/Version Version 21H2 (OS Build 22000.1696) as of 27MAR2023


    How do I force MS Office to trust a file?-excel-file-issue.png
      My Computer


  2. Posts : 16,895
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #2

    1 Right-click on the file, select Properties, it should open at the General tab. If there is an Unblock checkbox near the bottom right corner, click in it then click on the OK button.
    How do I force MS Office to trust a file?-properties-general-unblock.png
    2 Move the file somewhere under your control. I put script files & macro-enabled files, such as Excel add-ins, in sub-folders within a C:\Tools protected folder created for the purpose - see Set up my Tools folder ditty - TenForums
    3 In Excel, File menu, Options, Trust centre, Trust centre settings, Trusted locations, Add new location - add the path to your C:\Tools-equivalent folder and set the checkbox for also trusting its subfolders, OK, OK, OK.


    All the best,
    Denis
      My Computer


  3. Posts : 15
    Version 21H2 (OS Build 22000.1455)
    Thread Starter
       #3

    Try3 said:
    1 Right-click on the file, select Properties, it should open at the General tab. If there is an Unblock checkbox near the bottom right corner, click in it then click on the OK button.
    How do I force MS Office to trust a file?-properties-general-unblock.png
    2 Move the file somewhere under your control. I put script files & macro-enabled files, such as Excel add-ins, in sub-folders within a C:\Tools protected folder created for the purpose - see Set up my Tools folder ditty - TenForums
    3 In Excel, File menu, Options, Trust centre, Trust centre settings, Trusted locations, Add new location - add the path to your C:\Tools-equivalent folder and set the checkbox for also trusting its subfolders, OK, OK, OK.


    All the best,
    Denis
    Thanks for this, I will work on it and get back to you. It seems every time I go down a rabbit hole, 6 more cascade.
      My Computer


  4. Posts : 16,895
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #4

    And I have just been thinking about your Excel forms problem in ElevenForum.

    Is that file in a Trusted location? It ought to be as it's using an ActiveX control.


    Thanks for the rep,
    Denis



    And welcome to TenForums.

    It's really worth making time to browse through the Tutorial index - there's a shortcut to it at the top of every page.
    - At the foot of the Tutorial index is a shortcut to download it as a spreadsheet.
    - I download a new copy each month.
    - By downloading it as a spreadsheet I can benefit from Excel's excellent filtering capabilities when I search for topics of interest.
    - Tutorials are also listed by category at Tutorials - there's also a shortcut to that at the top of every page.
    - Both tutorial lists are searchable.
    - You can also search for TenForumsTutorials in many general search engines, such as Google, by adding site:tenforums.com/tutorials after your search term. For example,
    taskbar toolbars site:tenforums.com/tutorials

    You can search TenForums using the search box in the top-right corner of all TenForums webpages or using Advanced Search - TenForums
    - You can also search TenForums threads in many general search engines, such as Google, by adding site:tenforums.com after your search term. For example,
    Search for drivers by HardwareID site:tenforums.com
    - [This is what the search box in the top-right corner of TenForums webpages does automatically]
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 14:36.
Find Us




Windows 10 Forums