I have Excel templates into which I import data from a CRM. The formulae in those templates have stopped automatically calculating imported data despite the Calculation Option being set to automatic. Most of the formulae are numeric and when a value is manually added to any column the relevant formula is triggered and includes the manual and imported entries. There are two date functions (=Today()) and deleting / re-writing the function seems to be the only way to effect a result.

The templates have not been changed. The CRM has not been changed and the import procedure has been used for more than a year.

I see that a MS Office update was installed recently that might have caused the problem: 'This security update resolves vulnerabilities in Microsoft Office that could allow remote code execution if a user opens a specially crafted Office file.'

I would welcome any and all suggestions that help me find a solution as I have a significant number of templates that are affected