| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing a Pivot Table from a dynamic range
Hi there, I have a pivot table on one worksheet, that is refreshed from a rang of data on a second worksheet. the data is refreshed using a query, so can contain different number of rows. how can I code it to always refresh using the complete range from th data worksheet? can anyone help -- matp ----------------------------------------------------------------------- matpj's Profile: http://www.excelforum.com/member.php...fo&userid=2107 View this thread: http://www.excelforum.com/showthread.php?threadid=47787 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic range in Pivot table | Excel Discussion (Misc queries) | |||
| Using dynamic range to create pivot table | Excel Discussion (Misc queries) | |||
| Dynamic Range in a Pivot Table | Excel Discussion (Misc queries) | |||
| Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
| Refreshing a dynamic range variable | Excel Programming | |||
![matpj[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
