size problems (too many forumla?)

[Guest]

I have an xcel workbook with about 15 sheets, each one with about 200 IF Then
formulas and a another sheet or two with some Vlookup functions. It's 33 MG
and seems so big that its crashing a few people's computers. Is it the
formulas that are causing the size and how to fix? Thanks.

 

[PCLIVE]

If some of your sheets have formulas that were in place to do a one time
calculation, then you can copy all the cells on that sheet, and then Paste
Special - Values only. By 'one time calculation' I mean, now that the data
is in your spreadsheet, if the data that the formulas refer to is never
going to change, they you no longer need the formula...just the formula
result.

HTH,
Paul

 

[Bill Martin]

I have an xcel workbook with about 15 sheets, each one with about 200 IF Then
formulas and a another sheet or two with some Vlookup functions. It's 33 MG
and seems so big that its crashing a few people's computers. Is it the
formulas that are causing the size and how to fix? Thanks.

--------------------

My guess is that's not the problem. On one of your sheets press Ctrl-End. It
should move the cursor to the last cell on the sheet. If it moves the cursor
way further down, then Excel is storing a bunch of empty cells as if they have
stuff in them. It's a common problem. You can read more about it here, and
find a solution to try: http://www.contextures.com/xlfaqApp.html#Unused

Good luck...

Bill