View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Refreshing Pivot Tables QUery

Pivot Tables don't work that way. You would have to have enough space to
start with or put them side by side.

--
Regards,
Tom Ogilvy

"Ron McCormick" wrote in message
...
Does anyone know of a way of controlling
PivotTables 'refresh data' procedure so that where there
are two tables on one sheet the second table will
automatically be moved down (or up) when data in the first
table is refreshed?

TIA
Ron