Excel SUM not updating when data imported through Power Automate

(0) Share

Report

Posted on by 90paulwilson

Not sure whether this is more of an Excel Forum issue, but I am having trouble with my table not automatically totalling the amounts when the data has been added via Power Automate. Has anybody experienced similar and know how to fix it?

Thanks

All responses (1)

Answers (0)

90paulwilson 10 on at

Like (0)

Report

Re: Excel SUM not updating when data imported through Power Automate

I have added the Formula =SUM(E:E) to generate the sum in E2. I thought to use (E:E) rather than (E3:E100) to avoid any issues with the new rows being added, but still no luck. Any help greatly appreciated.