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 commented
I should also mention that all supported versions of Excel support tables, so compatibility is not an issue.