pivot table limitation?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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!
 
Back
Top