pivot table limitation?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

xrbbaker - 23 Apr 2007 16:32 GMT

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

Reply to this Message

Debra Dalgleish - 23 Apr 2007 16:42 GMT

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.

> Excel 2003
>
[quoted text clipped - 6 lines]
>
> thanks

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

xrbbaker - 23 Apr 2007 17:20 GMT

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!

> If you select the range name from the Name Box, to the left of the
> formula bar, is the entire range selected?
[quoted text clipped - 11 lines]
> >
> > thanks

Reply to this Message

Debra Dalgleish - 23 Apr 2007 18:26 GMT

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

> Debra,
>
[quoted text clipped - 19 lines]
>>>
>>>thanks

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Rate this thread: