ExcelBanter - Calculate (F9)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Calculate (F9) - Timeout (https://www.excelbanter.com/excel-discussion-misc-queries/223893-calculate-f9-timeout.html)

Calculate (F9) - Timeout

Calculate Workbook (F9) dies / doesnt refresh results in my spreadsheet. Are
there any quick tips to wake it up ?

Works sometimes, dies sometimes, no circular references

Yes my model has many formulae, and I've tried Calculating Sheet-by-Sheet

--
-----

joel

Calculate (F9) - Timeout

check what your maximum number of iteratons is set to.

Tools - Options - Calculation

"BR" wrote:

Calculate Workbook (F9) dies / doesnt refresh results in my spreadsheet. Are
there any quick tips to wake it up ?

Works sometimes, dies sometimes, no circular references

Yes my model has many formulae, and I've tried Calculating Sheet-by-Sheet

--
-----

All times are GMT +1. The time now is 09:59 AM.