AnsweredAssumed Answered

Insert Trend being blocked by Access Protection

Question asked by skasayulie on Dec 30, 2019
Latest reply on Jan 2, 2020 by jyi

Hello, I am receiving this error with PI Datalink's Insert Trend function in Excel, "The Trend Control can not be inserted because a worksheet protection is turned on. Please, remove protection and try it again." The function works if you disable "Protect Worksheet" but this causes one of the graphs in the Excel sheet not to load correctly. I did save the file with Protection turned off, closed it, reopened it and still got the same error. 

 

The user I am working with was able to edit the file on two other computers with "Protect Worksheet" turned on and use the Insert Trend function normally. Both the computers are on the same Office version. I did google the error but I was unable to find anything on the below attached screenshot of the error. I've also confirmed that this also occurs in a Windows 7 Citrix environment. Any thoughts/suggestions is appreciated. 

 

Windows 10 Office 365 Enterprise

Office version: 1808 (Build 10730.20386)

PI DataLink 2017 SP1 version 5.4.1

 

Outcomes