the four columns you nominated extended to 20,000 rows created a file of
1.13mb
Adding an extra column increased it to 1.73mb

adding a pivot table and choosing not to store the pivot table data
still gave a file size of 1.73mb .. a fairly trivial size these days.

If you want to keep the file at 1.3mb then perhaps you could change the
data you are given so you actually receive a cost and revenue column
rather than a cost and a % column.

good luck.

regards...


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=528399