ABB report excel, Stop DataDirect to try to update formula
Hi I'm trying to setup a report system on 800xA. I have successfully done a template and I'm getting all values I want using the formula ABBGetOPCHDA
As long as the reports stay inside the 800xA domain the reports work fine. But when I copy the excel report to a computer outside 800xA domain, every formula cell is showing #NAME? I think excel is trying to update the links when I open the excel workbook, and because I'm outside 800xA the OPC link fails.
The first thing that I will assume is that you have installed DataDirect into the PC outside the 800xA Domain with the same version that is present in the 800xA system. Once an Excel Report is moved from one PC to another, there are steps that must be followed. I have attached a short document to explain these and hope that this resolves your issue.
I guess the problem is happening as every time you try to open the excel report in a non 800xA domain, it tries to update the formulas to get the data, failing which it shows #NAME? Try changing the for workbook calculation option to manual from automatic in your report template and then open in the non 800xA computer.