Hi,

I have lot of pivot tables and want to use the offset function.



So I have two queries here:

1) Lets say I have table from a1:c:1000. I want to use offset function in this so that as soon as I have some data in the row 1001 it includes that in the table range and;

2) Also update the PIVOT Table data source.

Is it possible? Can you please tell me what I am suppose to enter in the offset named range to make the above possible.

Thanks

Regards

Umesh Banga

You don't need OFFSET or anything in XL2010.
Just declare your range as a table and use the table as source for the PT
It will include any rows added or removed automatically.
Of course the PT needs to be refreshed which can be done with some VBA eventually ( Google around for the code)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post