9-2-3

File Operations and Re-calculation

uTo save a file under a new name (Save As)1. In the S SHT mode, press 1(FILE)3(SV AS).• This will display a dialog box for entering a fi le name.2. Enter up to eight characters for the fi le name, and then press w.kAbout Auto Save

The S SHT mode has an Auto Save feature that automatically saves any changes to make to a spreadsheet fi le as you edit it. This means you do not need to perform any manual save operation.

kRecalculating a FormulaUse the following procedure to recalculate the formulas in a spreadsheet.uTo re-execute all of the formulas in a spreadsheetWhile the spreadsheet is on the display, press 1(FILE)4(RECAL).

This will re-execute all of the formulas and display the updated results in the applicable cells.

#If a fi le already exists with the same fi le name you input in step 2, a message will appear asking if you want to replace the existing fi le with the new one.

Press 1(Yes) to replace the existing fi le with the new one, or 6(No) to return to the spreadsheet without saving.

#Using Auto Calc

When “On” is selected for the “Auto Calc” setting on the Setup screen (page 1-8-5), all of the formulas in a spreadsheet are executed and cell values are update automatically whenever the spreadsheet fi le is opened, whenever the spreadsheet is edited, etc. The initial default setting for “Auto Calc” is “On”.

Formulas in a spreadsheet are not executed automatically if “Off” is selected for “Auto Calc”. In this case, you need to press 1(FILE)

4(RECAL) to re-execute formulas and update cell values when you want.

#The expressions in all cells are re-calculated when “Auto Calc” is “On”. This can cause the calculation to take longer.

20070201