Excel not Caling when populated from another program

[meltonk1]

I have a Cygnet SCADA system that will make a report in excel format. I am trying to use a template in excel. All this is available in the Cygnet program. Trouble is, when it populates the template, any formulas on the template don't calculate. If I go back and remove the formula and then put it back, calculation happens. This is a simple formula, like B1=A1. Ideas?

 

[RoryA]

Is calculation set to manual?

 

[meltonk1]

No, it is set to auto in the template.

 

[RoryA]

Do you know if it populates the template while it is closed? If so, you may need to do a Find/Replace and just replace = with = to force a recalculation of all the formulas.

 

[meltonk1]

OK. That appears to be the problem. Is there a way to fix this?

 

[RoryA]

You could add some code to do the replace when the workbook is opened or to trigger an Application.CalculateFullRebuild call?

 

[meltonk1]

I just tried that and yes that would work. But the template appears that it has to be an xlsx, so no code.