Re: Pivot tables
- From: swjtx <swjtx.208w9z_1134925202.4085@xxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 18 Dec 2005 10:56:50 -0600
Hi,
You could spec the columns as another user describes but I found that
that will tend to create a very large file since I guess the pivot is
looking at all 65000 rows. Another method I have used is just to look
at a larger range of rows. For example, if you have 2000 rows and you
are going to be adding 3 or 4 a week, it's going to take a long time to
get to 4000 so if you choose rows 2 to 4000, you will be safe until your
data exceeds 4000 rows. I had a worksheet with 36 pivot tables and 12
charts. Limiting the data made the file about 4 meg, choosing the
entire column made the file about 65 meg.
$A$2:$E$4000 (or whatever number you feel comfortable with)
You still have to refresh the data to see the changes.
--
swjtx
------------------------------------------------------------------------
swjtx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29716
View this thread: http://www.excelforum.com/showthread.php?threadid=494425
.
- References:
- Re: Pivot tables
- From: Debra Dalgleish
- Re: Pivot tables
- Prev by Date: Re: Hlookup/max value?
- Next by Date: Re: vlookup question
- Previous by thread: Re: Pivot tables
- Next by thread: Re: pivot tables
- Index(es):
Relevant Pages
|
