Microsoft Graph - Enable WEBSERVICE function on excel file to retrieve a computed value

KMK 1 Reputation point
2022-08-12T14:35:48.013+00:00

Hello !

I have the following workflow :

  • I receive some input
  • I put them in an excel file with microsoft graph and then retrieve a value computed in the workbook (no VBA just excel functions)

My issue : Some standard excel functions need to be enable for security purpose otherwise the computation in the file does not work and I get #VALUE.
I can do it manually on the excel file locally to get the value but when it's accessed by Microsoft Graph, I just retrieve the #VALUE output.
Is there a way to change the settings so that content is approved before Microsoft Graph retrieve the answer ?

Thanks in advance !

Microsoft Security Microsoft Graph
{count} votes

Your answer

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