AnsweredAssumed Answered

Error on execution of PI Datalink filling, Error "Unable to set NumberFormatLocal property of Range Class"

Question asked by Mogens_Petersen1 on Mar 7, 2018
Latest reply on Dec 9, 2019 by BenDupuis

When i execute a function in PI Datalink 2016 v. 5.3.0

Running Excel 2016

See more details below

 

I get an PI Datalink Error box "Unable to set NumberFormatLocal property of Range Class"

 

The date formatting in wrong a looks strange

 

- Does somebody know what is the problem and how to fix it

 

// Mogens

 

Data:

PI DataLink

Version

mscorlib 4.0.0.0 4.7.2115.0 built by: NET47REL1LAST

Microsoft.VisualStudio.Tools.Office.Runtime 10.0.0.0 10.0.60301.0

System.Core 4.0.0.0 4.7.2117.0 built by: NET47REL1LAST

System 4.0.0.0 4.7.2110.0 built by: NET47REL1LAST

System.Configuration 4.0.0.0 4.7.2046.0 built by: NET47REL1

System.Xml 4.0.0.0 4.7.2612.0 built by: NET471REL1LAST_B

System.Security 4.0.0.0 4.7.2046.0 built by: NET47REL1

Microsoft.VisualStudio.Tools.Applications.Hosting 10.0.0.0 10.0.60301.0

Microsoft.VisualStudio.Tools.Applications.Runtime 10.0.0.0 10.0.60301.0

System.Deployment 4.0.0.0 4.7.2046.0 built by: NET47REL1

Microsoft.VisualStudio.Tools.Applications.ServerDocument 10.0.0.0 10.0.60301.0

System.Windows.Forms 4.0.0.0 4.7.2110.0 built by: NET47REL1LAST

System.Drawing 4.0.0.0 4.7.2046.0 built by: NET47REL1

System.Xml.Linq 4.0.0.0 4.7.2046.0 built by: NET47REL1

Microsoft.Office.Tools 10.0.0.0 10.0.60301.0

Microsoft.Office.Tools.Excel.Implementation 10.0.0.0 10.0.60301.0

Microsoft.Office.Tools.Common.Implementation 10.0.0.0 10.0.60301.0

Microsoft.Office.Tools.Common 10.0.0.0 10.0.60301.0

Microsoft.Office.Tools.Excel 10.0.0.0 10.0.60301.0

OSIsoft.PIDataLink.UI 5.3.5976.30302 5.3.5976.30302

Microsoft.Office.Tools.Common.v4.0.Utilities 10.0.0.0 10.0.30319.1

OSIsoft.PIDataLink.Resources 4.2.0.0 5.3.0.0

Microsoft.GeneratedCode 1.0.0.0

OSIsoft.PIDataLink.AFData 5.1.0.0 5.3.0.0

OSIsoft.AFSDK 4.0.0.0 2.8.0.7444

WindowsBase 4.0.0.0 4.7.2117.0 built by: NET47REL1LAST

Microsoft.GeneratedCode 1.0.0.0

OSIsoft.PI.Net 1.5.4.0 1.5.4.21

OSIsoft.PI.Net.Core 1.5.4.0 1.5.4.21

Microsoft.GeneratedCode 1.0.0.0

CustomMarshalers 4.0.0.0 4.7.2046.0 built by: NET47REL1

OSIsoft.PI.Configuration 1.5.4.0 1.5.4.21

OSIsoft.PI.Configuration.PISDKRegDirectoryProvider 1.5.4.0 1.5.4.21

OSIsoft.PI.Resources 1.5.4.0 1.5.4.21

Microsoft.CSharp 4.0.0.0 4.7.2046.0

MDBTree.ocx 1.06.0365

PIDAEXTTREND.dll

PIDAXL.dll

PIDO.dll

PIDAArc.dll

PIPC32.xll 5.3.0.0

PISDK.dll 1.4.6.494

PISDKCommon.dll 1.4.6.494

PISDKCtl.ocx 1.06.0400

PISDKDlg.dll 1.08.0420

PITimeServer.dll

PITrend.dll

PIXLTWIZ.dll

OSIsoft.PIDataLink.Notifications.Common.dll 5.3.0.0 5.3.0.0

OSIsoft.PIDataLink.Notifications2007.UDF.dll 5.3.0.0 5.3.0.0

OSIsoft.PIDataLink.Notifications2007.UI.dll 5.3.0.0 5.3.0.0

Copyright (c) {0}, OSIsoft, LLC

 

Microsoft Excel Version 2016 MSO (16.0.4549.1000) 32 bit

Outcomes