Formulas are preserved in data forms when you refresh the data form even without saving the data, later open the saved worksheet, and when you expand or collapse rows and columns.
If you move a referential formula, its cell references are updated to reflect the new location. Note that formulas cannot reference data within the same grid.
In data forms, you are prompted to save the workbook as an Excel file if you do any of the following (but you temporarily lose access):