Is it possible to automate the recalculate (resize) function in excel?
Yes, it would be possible if you're willing to write a little bit of VBA in your spreadsheet.
Have a look at this KB article on the support website for details.
Dear god I hope so!
I am very willing to write some VBA, do you have some source code I can use?
thanks for you reply,
Have a look at the linked KB article - it includes a comprehensive code example for automating this. If you have any problems implementing this from the example, let us know and we'll help you out from there.
I have come across this one before actually.... the code bombs out at the line: automationObject.selectRange
with this error:
Hmmm... I had no problems running this code example. What versions of PI DataLink and Excel are you running?
The PI datalink version is: 5.0.0Excel is 2013
OK, so it looks like you may be using the wrong code sample. The KB article previously referenced contains code examples for different versions of PI DataLink, and the code that calls automationObject.SelectRange is for DataLink 2014 (v5.1) or later. For DataLink v5.0 you should be using the code example for PI DataLink 2013 and earlier, found in the bottom half of the KB article:
Let us know how you go with using that example.
I have gone through the file location looking for PIDLdialogs.xla and we don't have it, can I download it separately by any chance?Again, thanks a lot for your help I appreciate it.
No, it's not a separately available download. If this file isn't in your \PIPC\Excel folder, then possibly your installation is broken or corrupt. You could try running a Repair on your DataLink installation to restore this file. However i don't think your installation is corrupt, otherwise you would be having bigger problems if this file is missing.
I would just like to mention this functionality will be implemented natively in PI Datalink 2017.
Is this still likely to release by the end of June, as per the indication in the roadmap on the tech support site?
I always take these release dates with a grain of salt but I haven't heard anything that competes with the time line on the public site.
Yep, so things haven't changed a whole lot then
Retrieving data ...