Re-using formulas from the prior Snapshot

Top  Previous  Next

Where are My Old Formulas?

When you take a new snapshot of a QuickBooks form, it will overwrite any formulas you may have entered on the Snapshot tab of  the current FormCalc SST file.

If you've spent much time entering formulas, having them overwritten this way can be disappointing...until you learn that FormCalc SST makes a copy of them each time you take a new snapshot. Where is this copy of your formulas? On the OLD Snapshot tab.

To retrieve and reuse your old formulas, click on the OLD Snapshot tab. There you will find a copy of the text and formulas which were on the Snapshot tab immediately before taking the current snapshot. You can Copy (to the Windows clipboard) individual cells' formulas here, then go to the Snapshot tab and Paste them into the desired locations.

Notes:

Copy and Paste formula cells individually rather than as groups of cells. FormCalc SST's formula checking logic may raise errors when a group of formulas is Pasted in.

If you needed to take the new snapshot because of rearrangement of your QuickBooks form, many of the formulas you Copy and Paste into the Snapshot sheet may have to be adjusted (edited) after Pasting them in.