I figured out how to create a dynamic named data range I would like to use for a pivot table, but when creating the pivot table, how do you tell it to use that named range?

I got the info from http://www.contextures.com/xlNames01.html

Some background: I've been playing with pivot tables a little lately, but somehow, when I'm changing the reference data by removing or adding rows, when I update the pivot table I get an error that says it's only referencing 1 row. I hope this dynamic named data range thing fixes that. Please let me know if it will not.

Thanks!