I created a pivot table from "multiple consolidation ranges", and selected the option for this table to "refresh data when opening the file" After completing the table for that project and reopening it to update information in various rows I noticed that the pivot table did not update the sum values?

Any help with this is greatly appreciated.