Add trusted location via reg file unsuccessfully.

Vu Nguyen 41 Reputation points
2021-07-14T03:03:44.75+00:00

I have added a trusted location via reg file. However, it doesn't seem to be successful but cause the location is greyed out AND it doesn't have the expected effects of a trusted location.

What should I do to be able to add trusted location by registry?

This is my .reg file content and my screen shot

Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Security\Trusted Locations\Location8]
"Path"="%UserProfile%\\Desktop\\KTVP\\"
"Description"="KTVP Doc entry file"
"Date"="13/07/2021 06:58 PM"

114414-screenshot36.png

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
0 comments No comments
{count} votes

Accepted answer
  1. Viki Ji_MSFT 4,441 Reputation points
    2021-07-14T09:16:59.327+00:00

    @Vu Nguyen ,
    Welcome to Q&A forum!

    In the registry, the key value that defines the system variable path %UserProfile% is different from the regular path.

    If you add the KTVP folder as a trusted location through a .reg file, please change the path to "C:\Users\Administrator\Desktop\KTVP". You could right-click the KTVP folder, and then click Properties to view its specific location. Then double-click the .reg file to run this registry.

    Windows Registry Editor Version 5.00  
    [HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Security\Trusted Locations\Location9]  
    "Description"="KTVP Doc entry file"  
    "Path"="C:\\Users\\Administrator\\Desktop\\KTVP"  
    "Date"="13/07/2021 06:58 PM"  
    

    It is displayed in the registry as shown below:
    114469-image.png

    If you want use the "%UserProfile%\Desktop\KTVP" path, please add the following key value in Registry Editor directly and use Expandable String Value to define the folder path as shown below.
    114504-image.png

    My test results:
    114553-image.png
    Hope the information could be helpful to you. Any updates, please let me know.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    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.


1 additional answer

Sort by: Most helpful
  1. Tom van Stiphout 1,701 Reputation points MVP
    2021-07-14T03:26:46.257+00:00

    Grasping at straws: that is not a US date.