moderated Re: pivot tables in excel

Mark Fisher

I would be inclined to set my dataset up as a table, then in the data source for the pivot table, use the table name. That way, when you add data to your initial dataset, the table grows automatically and you don't have to worry about changing the range in the pivot table. 

Mark Fisher
Manager - People Systems
Water Corporation of Western Australia

Join to automatically receive all group messages.