AnsweredAssumed Answered

Datalink paste special

Question asked by DavidMFairchild on Jul 25, 2019
Latest reply on Jul 25, 2019 by DavidMFairchild

Starting with Windows 10 I have been unable to copy and paste values over PI Datalink query results.  I have used this technique for extracting PI data to send to people without access to the PI system.  I'm using PI DataLink 2017 SP2 with Excel 2016.  I select the entire output of the DataLink function, copy it (usually with Ctrl-C) and paste it over the selected range selecting "Paste Values and Number formatting".  This has worked for 20 years on all versions of Windows, Excel and DataLink but since going to Windows 10 I now get #N/A in all of the cells.