Calculated fields not updating after data import

Calculated fields not updating after data import

Hi,

I have encountered an issue when using calculated columns in my table. When I import new data (delete records and replace with new data) the calculations are not updating. The only way to get the fields to refresh is to edit the formula and either add or remove a space in it.

How can I get it to recalculate after the import without having to manually intervene?

Thanks.