The PI Datalink2017 addin is causing Excel to open slowly and gives the error "Microsoft Excel is waiting for another app to complete OLE Action". Has anyone seen this?
I have seen this issue occur when multiple AF Servers are listed in the AF Server list and one or more of the servers is not being used. I would check Datalink > Settings > Connection Manager to see if any unnecessary connections are being attempted.
Hope this helps!
Thank you so much for giving me this tip. Unfortunately, I did not have any unnecessary connections (I actually did have one before I posted-which I removed, and it didn't help my problem).
In addition to what Crosby Clouse mentioned, I would do the following tests:
Yes, if I disable PI Datalink Excel opens immediately. I have no other addins (tried everything). Thank you for your reply. I will read the articles. I've also got tech support involved. They suggested doing the following, which I did and I am no longer getting the OLE error, but it still takes 1 1/2 minutes to open Excel.
1) HKCU\Software\Microsoft\Windows\CurrentVersion\WinTrust\Trust Providers\Software Publishing\State from "0x00023c00" to"0x00023e00"
This can also be changed in Internet Explorer, go to Internet Options and click the Advanced tab. Scroll down to the Security section and uncheck the option that says "Check for publisher's certificate revocation."
More information can be found under the Work Arounds of KB00281: https://techsupport.osisoft.com/Troubleshooting/KB/KB00281/
2) HKLM\SOFTWARE\Wow6432Node\Microsoft\Office\Excel\Addins\PIDataLink Load behavior from 0 to 3
Retrieving data ...