108
Chapter 8 Pocket Sheet
Pocket Sheet Sync
Pocket Sheet Sync
for Microsoft
®
Excel 97/2000/2002
synchronizes Pocket Sheet data
stored in your PV Unit with data in files created using Microsoft Excel (97, 2000,
2002). For details on using Pocket Sheet Sync, see the documentation contained
on the CD-ROM that comes with your PV Unit.
Pocket Sheet Errors
The message
#ERR
appears inside of a cell any time one of the following
operations is attempted with the cell.
•
Division by zero
•
Any mathematical operation that produces a value that exceeds the
calculation limit
•
Any mathematical operation in which a cell references itself
•
Deletion of a row or column that contains a cell referenced by the cell
•
A copy operation that causes the referenced cell to be outside the sheet
•
Any copy operation, or row or column insert operation that causes the
length of a function to exceed 256 characters
•
Mathematical error
•
Adding a large number of mathematical expressions to a sheet for which
Auto Calculation
is turned off can cause the
#ERR
message to appear.
•
Parentheses can be nested up to 10 times inside a single calculation.
•
Referencing of other cells within the same sheet is limited to 256 levels
per calculation.
Important!
•
Referencing a cell that contains a calculation that has not yet been performed
may cause the referencing calculation to take a long time.