i'm using a marco in worksheet A that contains the table data to update
multiple pivot tables / charts in workshhet B. i'm using the name function
to define the rows & columns (called it data) which contains the entire data
range of worksheet A. after i add additional rows of data in worksheet A, i
want to use the macro to 'redifine' the new data range & use that to update
worksheet B. while recording the macro, i started in cell A3 (the header row
where my data starts) & hit the Ctrl+shift+end keys to highlight the data. i
then deleted the name Data & re-added it, thinking this would update the name
data for the Pivot tables / charts. but it doesn't. is there a way or code
that can be used to redefine the name so my tables willget update with the
most recent data?

Try basing the Pivot Tables on a Dynamic Range Name, which automatically
expands and contracts with the data. See Debra Dalgleish's website for
instructions.

http://www.contextures.com/xlNames01.html#Dynamic

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Wilkesy" wrote:

i'm using a marco in worksheet A that contains the table data to update
multiple pivot tables / charts in workshhet B. i'm using the name function
to define the rows & columns (called it data) which contains the entire data
range of worksheet A. after i add additional rows of data in worksheet A, i
want to use the macro to 'redifine' the new data range & use that to update
worksheet B. while recording the macro, i started in cell A3 (the header row
where my data starts) & hit the Ctrl+shift+end keys to highlight the data. i
then deleted the name Data & re-added it, thinking this would update the name
data for the Pivot tables / charts. but it doesn't. is there a way or code
that can be used to redefine the name so my tables willget update with the
most recent data?

Ron,
Thanks for info. works like a charm.....

Regards,
Wilkesy

"Ron Coderre" wrote:

Try basing the Pivot Tables on a Dynamic Range Name, which automatically
expands and contracts with the data. See Debra Dalgleish's website for
instructions.

http://www.contextures.com/xlNames01.html#Dynamic

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Wilkesy" wrote:

i'm using a marco in worksheet A that contains the table data to update
multiple pivot tables / charts in workshhet B. i'm using the name function
to define the rows & columns (called it data) which contains the entire data
range of worksheet A. after i add additional rows of data in worksheet A, i
want to use the macro to 'redifine' the new data range & use that to update
worksheet B. while recording the macro, i started in cell A3 (the header row
where my data starts) & hit the Ctrl+shift+end keys to highlight the data. i
then deleted the name Data & re-added it, thinking this would update the name
data for the Pivot tables / charts. but it doesn't. is there a way or code
that can be used to redefine the name so my tables willget update with the
most recent data?