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