Forum Discussion
Append data using power automate and office scripts
Hi, New to the forum, hopefully my post provides adequate information to assist and I'm not breaking any etiquette with my post. Scenario: We have some excel spreadsheets that come in every mont...
Wouldn't it be simpler to format the data in the master sheets as table and let Excel handle the formula columns?
There are a bunch of other processes that use the data from the master spreadsheet. I would need to go and modify all of those to work with table data. Its definitely going to be easier to leave the data format of the master spreadsheet alone if possible.
