Ranges & Pivot Tables

Dear Dagna

Thank you for attending Excel Advanced course!! I hope you enjoyed the course and benefited from it.

Please refer to the following link to help you create a dynamic named range. The advantage of dynamic named range is that when any data is added or deleted from the existing range it automatically adjusts itself.

http://support.microsoft.com/kb/830287

Please refer to the uploaded file that I downloaded from one of the websites. It has some examples of the dynamic named ranges. Please feel free to experiment by adding/Deleting extra rows/columns to see how the results vary.

You can use CTRL +Z (Undo) to get back to the original.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Dear Dagna

Sorry in addition to my pervious post to have dynamic named ranges for your Pivot tables you can refer to the following links that provide you easy step by step instructions:

http://www.contextures.com/xlPivot01.html

http://msexcelraj.wordpress.com/2007/07/01/how-to-create-a-dynamic-pivot-table-in-ms-excel/

The above links are a good source to understanding dynamic ranges in Pivot table!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT