Microsoft Office Document Customization This document contains custom code that cannot be loaded because the location is not in your tn_lsted locations lists

Question

Dear Admin,

I got this warning when I develop excel using workbook VSTO in OneDrive folder, and once I start debug, I got this warning: "This document contains custom code that cannot be loaded because the location is not in your ....... locations lists ...... " But If i copy my project to another folder which is out of OneDrive folder, everything is OK.

Can you show me how to fix it, Because I need to update this file and sync on OneDrive and then I can use it in another computer

Thanks for reading

Answer 1

I am facing same issue. tried to add locatin to rust center. Does not help. Can you suggest?

Answer 2

Hello,

Welcome to Microsoft Community and appreciate your time taken for sharing detailed information. I could share with you some of my thoughts on this issue.

I want to ask if this question happened suddenly. Have you ever encountered such a situation before? There is no problem for you to copy it to another non-OneDrive folder, I think it is possible that there is a problem with your save path. Maybe you can try to add the path saved to OneDrive as a trusted location in Excel.

1. Click File > Options.
2. Click Trust Center > Trust Center Settings > Trusted Locations.
3. Click Add new location.
4. Click Browse to find the folder, select the OneDrive folder, and then click OK.

And then see if it works.

Feel free to post back if you need any further assistance.

Best Regard,

Kevin | Microsoft Community Support Specialist

---

*Beware of scammers posting fake support numbers here."

*Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here.

*If your problem is not solved, you could reply to the post again and we would continue to provide technical support for you.