Saving iteration information in Excel




Why is the iteration information in Tools--Options--Calculation not saved in Excel when I exit, while other options are?

Excel stores most options under the file excel5.ini in Excel 5 or the registry if it's Excel 7. However, iteration options are saved under the default workbook book.xlt.
You can find book.xlt in the startup directory under the Excel directory if Excel is installed locally.
If it is a network-installed copy of Excel, specify an alternative startup directory in Tools--Options--General, then save the workbook with the new information as book.xlt in that directory.

Category: Digital Helpline, Spreadsheet
Issue: Apr 1997
Pages: 184

These Web pages are produced by Australian PC World © 1997 IDG Communications