Recalculating all the Excel files stored in a SharePoint library

(0) Share

Report

Posted on by Community Power Pla...

I need a way to recalculate all the formulas within several Excel files stored in SharePoint without having to open, save then close them all one by one. Is this possible?

Thanks.

Categories:

Business Process Flows

All responses (2)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Recalculating all the Excel files stored in a SharePoint library

Thanks, guess I just have to do something using VBA
Verified answer

v-alzhan-msft on at

Like (0)

Report

Re: Recalculating all the Excel files stored in a SharePoint library

Hi @Anonymous ,

No, since Microsoft flow couldn't work with excel table that has formulas in it.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.