moderated Re: pivot tables in excel


Mark Fisher
 

Hi
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 main@jfw.groups.io to automatically receive all group messages.