Cell References Not Updating in Spreadsheet Formulas

A problem exists in ClarisWorks 1.0 v1 for Windows where cell references in formulas with very long text strings do not always get updated correctly. Shortening the formula or placing the string in another cell and referencing it in the formula should fix this problem.

This information was provided by Claris Corporation on 16 March 1998, and incorporated into Apple Computer's Tech Info Library.

Cell references in spreadsheet formulas with very long text strings do not always get updated correctly.

There are two simple workarounds to this problem:

1. Shorten the text string in the formula.

2. Put the long text string in another cell and use a reference to it in your formula

Example: If your formula currently reads as:
="Total this Quarter in US Sales - $"&SUM(A1..A10)
you could place "Total this Quarter in US Sales - $" into a cell (e.g. C20) and reference it in your formula:
=C20&SUM(A1..A10)