refresh pivot table with New source data without changing tables

B

broro183

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table refresh problem 0
Pivot tables not refreshing after data source update 1
Code to Refresh inbound data sheets, then Refresh Pivot Tables 3
How to refresh a pivot table that uses changing source data 1
How to build / refresh pivot table without ODBC?? 1
Refreshing some Pivots Tables makes Excel stop or crash 0
Refreshing some Pivot Tables makes Excel stop or crash 0
Retain pivot table formatting after refreshing data 0

Top