How can I copy and paste formula values from one Excel tables to another using Power Automate?

(0) Share

Report

Posted on by AmyB_214

I have an Excel worksheet that has formulas referencing many other worksheets. These values are regularly updated based on what's entered on the original worksheets. I'd like to be able to share a version of the sheet that contains values so that I don't have to give access to all the ancillary sheets to everyone that needs to see the "final" values. I tried to use Power Automate to update a Sharepoint List, but it seems that this will only work if there are values and not formulas in the cells.

Can someone please help with a flow that runs daily and will copy data from the table with formulas and paste values in a new sheet?

For example - Workbook A has formulas referencing Workbooks B, C, D. I want to copy those values and paste them in Workbook Z and only give access to Worksheet Z to the stakeholders. I would like this to happen daily so stakeholders always have updated information.

Thank you!