Use Excel tables to contain PI Builder data
PI Builder should use tables (the kind of table found in the Insert tab on the Ribbon) whenever headers are set up and whenever data is imported from the PI Data Archive or the PI Asset Framework.
Benefits of PI Builder using tables:
• filters are on by default, and they do not use up the 1 filter that is allowed per sheet
• readable formulas that automatically fill the table column
• explicit isolation of PI Builder data from the rest of the sheet
• banded rows are an option
14
votes
Kenneth Barber
shared this idea
1 comment
-
Kenneth Barber
commented
I should also mention that all versions of Excel, that the latest version of PI DataLink supports, support tables, so compatibility is not an issue. (The first 2 commas were added for clarity but are grammatically incorrect.)