I'm looking into using a template where I have a tab with two pivots that are tied to two different tabs with excel tables (vba ListObject).

On the data tabs that will be replaced by WF, is it possible to have WF place the data in the tabs as an Excel table (vba ListObject) so the source of the pivots can be just "myTable1" and "myTable2" rather than specifying an actual range (for example A:Z) which might include blank rows?

This message has been edited. Last edited by: FP Mod Chuck,

So you have a template with 3 sheet? Sheet 1 contains your pivots and the other 2 sheets contain data table from WebFOCUS? If I was doing this I would not have any blank rows in my data tables, then I would have an Auto-Open macro that would redefine myTable1 and myTable2.