Formulae dont calculate on imported data

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

The templates are imported to the CRM where the data is loaded and the loaded file is then exported to Excel. I have checked that the formatting set in the template is retained throughout the process. Until recently all files exported to Excel using this system worked flawlessly: I would open the file in Excel, protected view and when I 'Enable Edit' the calculations would all be done.

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi John, Thanks for offering support - sorry for my delay answering, I wasn't notified of your thread!
I'm attaching a de-sensitised representation of a typical Excel file exported from our CRM that shows all the formulae uncalculated - (at D/E6, G6, D31, E31, F31) - except G15 where I re-wrote the formula after export.
Perhaps significantly, I'm seeing this result on my PC using Office 365 Personal with the latest Office updates, whereas the Office PCs are not set to automatically instal updates (latest Windows 10 update was on 18 December 2017) but the Office PCs, using Office Professional 2016, are not suffering 'my' problem

Excellent advice, Glenn. Thank you