
Hi All,
I am maintaining a Excel spreadsheet on SharePoint. I am fetching forms output in one of the table (Table1).
In Table2 i have applied some formulas which are based on the Table1 inputs. Now without opening that Excel spreadsheet Table2 formulas are not working.
Is there a flow by which i can update those formulas without opening the Excel Spreadsheet?
Regards,
Sahil Mittal
The Flow is like:
1) Getting data from Forms (Table 1)
2) Calculations based on Forms Input (Table 2)
3) Listing and pasting the calculated Table 2 on separate Excel Sheet Table 3
4) E-Mailing the Table 3