View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE
 
Posts: n/a
Default size problems (too many forumla?)

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

"Woody13" wrote in message
...
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.