I'm using office script and want to apply a vlookup column from another workbook but when i'm running the script through web it returns me #N/As and in order to avoid #N/As it needs to fix the trust settings of external workbook. Can anyone from the community help to sort this issue for me to achieve the output as my main target is to run the script from power automate.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
397
