DSUM with dynamic criteria not updating in Excel 2010

Good Day.

I'm new to the forum so hopefully someone can help me out.

I have an excel file with DSUM dynamic criteria i.e. using formulas. The strange thing is that it's not working/updating in excel 2010 at work, however, I took home the same file where I have excel 2007 and the DSUM with the dynamic criteria worked. I've attached the excel workbook. It's in the "New Method" tab. DSUM formulas are in M4 to M8.

I'm at work now and I'm not sure if there's a particular setting that's different between excel 2010 and 2007.

Appreciate any help that I can get. It has me stomped for a couple of hours trying to figure it out.