File size grows to unrealistic proportions

Originally Posted by kevsvette

I run a fantasy league & use excel for the weekly results

Because it has Year to Date information I have to add to the document on certain tabs so I copy n paste the file from one folder to another from week to week.

I've done this in the past & haven't had any problems, but now I have added some formulas (index/match & some other sum formulas) & it has grown from 144k to 1500k to recently 34mb.

I have excel 2000. I know that this isnt probably enough information but I thought I'd throw it out to get some feedback & answer any questons that you might have to figure it out.

Hi,

take a look at http://www.beyondtechnology.com/tips019.shtml

hth
---