Using .Net 22.214.171.124
Since upgrading from 126.96.36.199 yesterday to fix the freeze panes issue I've been getting lots of #Value! errors throughout my spreadsheet. If I go into the formula bar and either press enter or press the tick then the formula is correctly calculated. If I go back to 188.8.131.52 it works as expected. I have attached a example of the problem - if you look at 4 QTR Data Summary!P41 it contains #Value! but is a valid formula against valid data. It is also possible to change the formula to contain a SUM and it will work as in:
A1+SUM(B1:B5) changed to SUM(A1)+SUM(B1:B5)
if that helps solve the problem.
Can you have a look at it?