Pivot Data Range

[rajeev.raj]

Dear Experts,

I have one datasheet and based on that I have created a Pivot Table and it works fine.

The issue is there are data entry on daily basis and every day rows increase.

Every time I go to select data source to update the pivot table.

Is there any way to pivot table select last used row doe its data range.

Please help on this issue.

Thanks in advance.

[Shareez Saleem]

Either convert your data to a table (Ctrl+T) or set a named range using offset function.

Please Login or Register  to view this content.