Hi There,

I've having trouble with what appears to be some kind of glitch. The formulas in the linked spreadsheet (it's too big to attach, sorry) are not displaying the results of the formula, although the formula is definitely correct because the F9 evaluation yields the correct result. Can someone please take a look and see why this might be happening? I've googled across the web but no answers I've seen appear to solve the problem. As a clue, I've noticed that if I delete all the blue sheets (Kay Rd Subdivision (250) - Blackwood RoW (258), the problem is solved. Of course, though, I don't want to delete these sheets...

I'm also having a problem with circular references. Whenever I use the today() function, excel is deeming it a circular reference. Does anyone know why this might be?

https://drive.google.com/file/d/0B3g...ew?usp=sharing

Thanks for your help.


Nathan