Manual Update of Auto-Enter Calculation

[kevybaby]

I have several fields that are auto-enter data via a calculation ("pull info from fields B, C, D, etc."). These are set up as auto-enter calculations because it populates the target field not just with the raw data but often additional verbiage as well as many other factors. The purpose is to take the details of a Quote Request to create a Quote Letter that could be sent to a client. They are auto-enter calculations so that the salesperson can alter the verbiage as needed for the Quote Letter - the initial data is populated as a starting point (and often remains as entered) but allows for necessary customization.

 

(I have inherited this database and the original designer did not make the Quote Letter a separate table, though I have been contemplating splitting it out to a separate table.)

 

The calculations are all set to replace existing data so that if anything changes in the referenced fields, the target field is supposed to update. However, I have found that there are instances this isn't happening properly and I could use a way to manually trigger an update. I know that I could copy the formula (sometimes VERY lengthy) and create a button that would replace the contents of the cell based on the same formula, but I am concerned about having the same formula in two places (always concerned that an update will be made in one place, but not the other, though I could put a comment at the beginning to note to change in the "other" place). Is there a way to tell the field to update based on the Auto-Enter Calculation formula?