5.6. Model Updates

Like all spreadsheet programs, Excel tries to avoid doing unnecessary recalculation. If nothing has changed in a spreadsheet, it does not automatically recalculate it. Even the Excel command Options | Calculate Calc Now (F9) will not force a spreadsheet to recalculate if nothing has changed in the spreadsheet itself.

This can be a problem with Aqwa results where models may be rerun: as far as Excel is concerned a function asking for (say) the position of structure 1 at a particular time-step does not need recalculating if none of these numbers have changed - it does not take account of the fact that the data in files outside Excel may have changed. This consideration applies even when a spreadsheet is closed and re-opened or Excel restarted.

To force all the results to be reloaded, make a null edit of the model name (as used in the first argument to each AQL function) by clicking on the cell, then pressing F2 to edit the cell, then enter to accept the edit. Excel will recalculate the spreadsheet and update all the values.