| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing a Pivot Table from a dynamic range
Is there a defined name for the table, something like External_Range1 or
something close to that. Use that name as the source for you pivot table. -- Regards, Tom Ogilvy "matpj" wrote in message ... Hi there, I have a pivot table on one worksheet, that is refreshed from a range of data on a second worksheet. the data is refreshed using a query, so can contain different numbers of rows. how can I code it to always refresh using the complete range from the data worksheet? can anyone help? -- matpj ------------------------------------------------------------------------ matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076 View this thread: http://www.excelforum.com/showthread...hreadid=477871 |
| 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 | |||
Threaded Mode
