Thread: Changing Pivot Table source
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jerredjohnson
 
Posts: n/a
Default Changing Pivot Table source

As we move, we are changing to a new database. I have pivot tables for
40 distributors that I update data on monthly. Can you change the Data
Source of the database? This way I wont have to redo 40 pivot tables

Thanks!


--
jerredjohnson
------------------------------------------------------------------------
jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236
View this thread: http://www.excelforum.com/showthread...hreadid=538453

Reply With QuoteReply With Quote