Quattro Pro: Formulas change when I cut/paste or move cells

0 users found this article helpful

Symptoms

When I cut / paste one or more cells, QuattroPro alters any formulas referring to those cells even though I want the formulas to remain the same.

Cause:

QuattroPro modifies the cells to keep the formulas pointing to the original values / data source.

Resolution

Save your spreadsheet to a new name before proceeding. This creates a backup of your work.

Use copy / paste instead, then clear the original cell's data using the DELETE key on the keyboard. This will prevent the f

Was this article helpful?

Tell us how we can improve it.