Edit document does not reflect the changes in view file macro

The issue is that the Total sheet did not display the same value/data in Confluence page as in the original file. Updating values in other sheets should be reflected in Total sheet. But this is not the case as the value was not updated in Confluence page. However, the strange part is, the values will be updated and will be displayed correctly as the original file if Total sheet is re-arranged/move to other than the first position tab.