file size becoming heavy

**Masa1989** · 12-31-2014, 07:00 AM

Hi
I have this sheet reatil working which has become 20mb with limited use of formulas
Same sheet need to be replicated 5times for 5diff channels, would become 100mb with same sets of formulas
request if any of u guys can help me out with any alternate method or formulas so as to keep file size as min as possible
any help would highly be appreciated
Thanks in advance
Hapy New year
i am not able to attach its 20mb, any ways to upload heavy file for your reference

**Richard Buttrey** · 12-31-2014, 07:11 AM

Hi,

Have you checked where the last used cell is on every sheet? Use {End} {Home} to find it.
What's the formula you're using and how many rows/columns are there on the sheet.

Sometimes it's the case that a formula has been copied down to row 1048576 at the very bottom of the sheet.

Just a thought for when you do eventually do reduce the size, but why not stick with a single sheet and add an extra column to record the Channel value of each record. This is likely to be much more efficient for any subsequent data analysis and will of course allow you to use a Pivot table for summarisation and analysis.

**Richard Buttrey** · 12-31-2014, 07:20 AM

I've just realised this is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.