I use a series of worksheets to track information throughout the year (1 sheet for each month) I have a seperate sheet to grab totals from the other sheets (='4-8 Feb'!H19 for example) but as i update the "monthly" sheets the "total" sheet that references them does not automatically update - how do i get excel to do that
Hi Can you check to see if "automatic calculation" is ticked in "advanced/formulas"?
If it is, let us know and we'll come up with some other solution.
