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 •


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

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.


Report •
Related Solutions


Ask Question