pivot table limitation?

[Guest]

Excel 2003

I have a block of data 13 columns wide, by about 1500 rows. I'm feeding
that as a source to my pivot table. The PT seems only able to digest the
first 810 rows. I tell this by clicking on Pivot Table Wizard, back, and
seeing the Range that it has highlighted, which is smaller than the range
Defined as a Name. Is this simply a limitation of Excel? I get from
KB820742 that there are no row limitations.

thanks

 

[Debra Dalgleish]

If you select the range name from the Name Box, to the left of the
formula bar, is the entire range selected?
Or if the name is a dynamic range, perhaps there's a problem with the
formula.

 

[Guest]

Debra,

Argh. I have two Named Ranges similarly labeled. I modified one, but was
using the other. Apologies. Thanks.

p.s. Thanks so much for your Contextures site. It is very helpful. Friday
I added your code for the Data Validation Combo Box. It works great!

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that combo box code worked
for you.