Update Excel
Using the older versions of Excel, this was a problem when the spreadsheet got too large. If I recall a solution was to go to the Tools menu, then Calculations and check the box for Inerations. If that does not work, it may be necessary to bump up the number by 100 at a time...