PivotCharts (max cell/row limits)?

  • Thread starter tico6802 via OfficeKB.com
  • Start date
T

tico6802 via OfficeKB.com

I've recently created an Excel spreadsheet to track Utility (water, sewer,
electricity) consumption and costs at 5 different locations...tracking the
past 3 years. It's 11 columns wide and is now on it's 389th row.

To view the data graphically (i.e. by individual site or type of utility) I
am using PivotCharts...which by the way are AWESOME!

Unfortunately, when I'm trying to view the last site I'm unable to view all
of it's data...oddly enough it stops at about 260 of the 388 records/rows.
I've hit REFRESH but still nothing. Are these two related? (I figured, it
might but was expecting 255/256 and not 260).

Thanks for any and all help!!! Rigo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weird behaviour of VBA when generating multiple PivotCharts 0
Microsoft Excel Cell text limits 3
Auto filling data in rows 1
[EPM 2007] Can we set-up resource max-unit at server level ? 4
dealing with max number of fields 5
How to sum when the criteria and the range are in the same row? 2
Excel Import - data limitation 0
Comparing then populating 1

Top