Filter
Top Products
20050401
9-2-3
File Operations and Re-calculation
u To 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 file name.
2. Enter up to eight characters for the file name, and then press w.
kk
kk
k About Auto Save
The S
•
SHT mode has an Auto Save feature that automatically saves any changes to make
to a spreadsheet file as you edit it. This means you do not need to perform any manual save
operation.
kk
kk
k Recalculating a Formula
Use the following procedure to recalculate the formulas in a spreadsheet.
u To re-execute all of the formulas in a spreadsheet
While 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 file already exists with the same file name
you input in step 2, a message will appear
asking if you want to replace the existing file
with the new one.
Press 1(Yes) to replace the existing file 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-7-5), all of the
formulas in a spreadsheet are executed and cell
values are update automatically whenever the
spreadsheet file 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.