Getting error #NAME? while looking Current Value of tag inside Excel ? I want to get the tag data from PI Server and Save those data into excel after each 12 hr from current timestamps. Should I write Macro for that ,please suggest me ?
This problem could be related to PI DataLink add-in loading issue. Ensure pipc32.xll add-in is enabled in Excel. To do this press Home button in Excel->Excel Options->Add-ins. If it is not enabled, Make sure that the pipc32.xll is NOT in the Excel Options/Add-Ins/Disabled Items list.
If this still does not work, then from the Home button, select Excel Options->Trust Center-> Trust Center Settings button -> Select Add-ins on the left hand side and make sure "Require Application Add-ins to be signed by trusted publisher" is unchecked.
Hope this helps.
There's a KB that might help with this KB00575 - '#Name ' is returned in the cell when a PI function is invoked in PI DataLink
Retrieving data ...