Hi people.. I'm using Excel 2010, I have a workbook with 5 sheets. They have some formatting. The problem sheet is the helper sheet. It has about 30 columns with formulas. I was going to have some of the formulas go to the end of the sheet, but abandoned that idea when it started crashing. That one sheet alone is over 20mb, it has minor cell background colour formatting in the columns with formulas to make it easier to read. Is it normal for excel to consume so much space?
When trying to do anything with it now, Excel complains there's not enough memory. I've got 4gb. Is that normal?
It's driving me nuts. It's the sort of thing you expect with freebie software, not from the biggest software company. Especially as they made the operating system too.
Any Ideas what's causing it?
Thanks