Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
size problems (too many forumla?)
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
size problems (too many forumla?)
Woody13 wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My tabs' font size is smaller - how do I restore default size? | Excel Discussion (Misc queries) | |||
Print Excel charts in Word 2003 with fixed size | Charts and Charting in Excel | |||
Combo Box font size in Charts | Charts and Charting in Excel | |||
Font size in conditinal formatting | Excel Discussion (Misc queries) | |||
Has anyone had problems setting the font size for a title through VBA? | Charts and Charting in Excel |