ProcessBook stores tags by their pointid. If you change the name of a tag, It will still show up in ProcessBook. We would like to have the option to store tags in Xcel by the tag number instead of the name.

As an example, we are getting ready to change allot of PI tag names, it would be nice to convert the spreadsheet to save current tags by pointid, then save the file. Change our PI tag names, then reopen the file and reconvert it tag names. When we change PI Tag names, we want the spreadsheets to still function.

Whenever Daylight Saving Time starts on Brazil the issue below is prone to happen:

Whenever Start/End time has a date corresponding to DST start, which will either cause date misinterpretation (using formats XX-XX-XX or XX/XX/XX) or throw an error (given DateTime represents an invalid time).

Customers want to avoid having to install a localhost to client machines and having to make changes to every spreadsheet.

When we use Datalink to select the child attributes, you have to select them one at a time. Being able to select several at once would be nice.

When AF Elements contain hierarchical attributes, there is currently no mechanism to use the Asset Filter Search to bring in the child attributes... only the parent attributes are returned..

This is already documented in this KI
https://techsupport.osisoft.com/Troubleshooting/Known-Issues/40739

PI DataLink (specifically, the right sidebar that pops up when entering a current or archive value) is very hard to read in Dark Theme (office 365 only). If this could be resolved, that'd be great

Element Template field doesn't accept multi-cell referencing - only the 1st referenced cell will take effect. Known Issue 91547 is exist.

The issue is that not all attributes displayed in the attribute to display section on the Asset Filter Search in MS Excel when range of the element template is chosen.

Excel VBA code can invoke the resize/recalculate function on Datalink array formulae.  However this requires selection of the array and this pulls the appropriate Task Pane into view (unless the Datalink setting is in force that turns this off).  It would be good if the VBA code could hide this Task Pane, but trying to do this currently causes an exception.  See PI Square thread: https://pisquare.osisoft.com/message/116861-re-is-there-a-way-to-force-a-pi-datalink-array-formula-to-recalculateresize-using-vba-automation

For international companies, it would be good having the possibility to use the new AF UOM Groups in DataLink, so that each user could see data with the UOMs he is more comfortable with.
It would be even better if these would be selected automatically depending on the user region (though it should be possible overriding this setting).

Currently, the Root Path field of Datalink can be pointed to a single cell to retrieve the name of the Data Archive where the tag resides.

It is not possible to specify an array of cells, as only the first Data Archive will be considered.

There are workarounds for this, such as:
- using an Excel formula to concatenate the root path and the point name and call the obtained cell from the DataItem field
- using single-row queries instead of array queries

Still, it would be nice to have an array-query option also for the Root Path field.

The values of timestamp tags or AF attributes should be formatted as timestamp in Excel by default. Currently they are returned as integers, and then users have to manually convert them into timestamps.

Compressed Data should be able to (or have the option to) query multiple tags and return the results as a single table/array of information, instead of independent columns of data. Returning independent columns of data results in rows being mismatched across multiple columns because of missing events. A table should be able to be easily created that keeps the data from multiple tags contextualized with each other based on the time stamps.

Currently, you can only use "Recalculate (Resize) Function" on a single array formula at a time.

Instead, please consider implementing this rule: all PI DataLink array formulas that have ≥1 cell in the selected range get recalculated and resized.

As a user of PI Datalink in Excel, I would like to return the values of attributes specific to a "Category" as specific in AF.  Currently I can perform this search using PI Builder but cannot easily combine PI Datalink functions without the implementation of a custom wrapper and VBA.

In PI DataLink, using the Explore Events function, I would have expected the list of Event Frames displayed to refresh with newly created event frames when my end time is current time '*'. I would also expect that the list of Events is up to date when I open Excel and PI DataLink.

We are able to currently see annotations for Event Frames but there is no easy way to quickly get a bulk export of Event Frames with Annotations along with what was attached to it, be it file name or path. It would be good to have another column that can pull in the attachment data that was associated with the EF and annotation.

As a DataLink user, I would like to see the values of the attributes during the starttime and endtime period of each event frame that I pull into the DataLink using Explore Events tool. So that I don't need to ask for the compressed values during that time range for each of the attributes manually.

I would like the ability to disable automatic connections to specific AF Servers. Currently client applications (DataLink) are implicitly connecting to all AF Servers in the AF "KST". This results in very slow startup times for Excel. For customers with many AF Servers or off-shore servers connected via satellite, this could save a lot of time.

Enable DataLink (Explore Events) to display the timestamps of calculated attributes (e.g. maximum, minimum) of an Event Frame.
Currently only the values are displayed. In PI System Explorer the requested timestamp is available.

Reference to a former discussion in PI Square: https://pisquare.osisoft.com/thread/13436