Solved Excell 2010 - referencing different sheets

February 8, 2013 at 14:34:36
Specs: Windows 7
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

See More: Excell 2010 - referencing different sheets

Report •

February 8, 2013 at 15:21:47
✔ Best Answer

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.

Report •
Related Solutions

Ask Question