Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

ranges within tables

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Ranges within tables

Ranges within tables

ResolvedVersion 2007

Kalpna has attended:
Excel Advanced course

Ranges within tables

autoincrease rage that gets picked up on pivot table or name range.

RE: Ranges within tables

Hi Kalpna

Thanks for getting in touch. The best way to do this is convert your range into a Table.

Click inside your source data and then go to Home > Format as Table. If you build a PivotTable off this Table your range will increase as more rows are added. Next time you Refresh you will see the appended data included in your PivotTable.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 13 Dec 2013: Automatically marked as resolved.

Excel tip:

Missing Field handle

If your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.