Skip navigation
All Places > All Things PI - Ask, Discuss, Connect > Ideas

Use Excel tables to contain PI Builder data

score 10
You have not voted Submitted
Originally posted 3/20/2017 1:10:51 PM UTC

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