Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default refresh pivot table with New source data without changing tables


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default refresh pivot table with New source data without changing tables


hi,

There is no question in your post & not very much detail either, can
you please clarify exactly what help you want?

I'm taking a longshot here but at a guess you may find the following
link useful (assuming that your aim is to be able to update the data
range of a PT when new info is added): 'Excel -- Pivot Tables -- Dynamic
Data Source' (http://www.contextures.com/xlPivot01.html)

hth
Rob


--
broro183

Rob Brockett. Always learning & the best way to learn is to
experience...
------------------------------------------------------------------------
broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98451

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Data Source on Multiple Pivot Tables at once marjhan Excel Worksheet Functions 1 October 23rd 08 09:03 AM
pivot table source data expand to new entries when refresh? DianneZ Excel Discussion (Misc queries) 4 October 14th 08 03:58 PM
Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table's Source Range) Mike C[_5_] Excel Programming 3 February 15th 08 06:22 AM
How to refresh a pivot table that uses changing source data Mike C[_5_] Excel Programming 1 February 13th 08 01:54 AM
Pivot Table data source "data source contains no visible tables" Jane Excel Worksheet Functions 0 September 29th 05 08:28 PM


All times are GMT +1. The time now is 09:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"