Large File size

[Pete_P.]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)

After generating a new file by copying and pasting data from an Excel 2004 file into Excel 2008, and inserting my lists and VLOOKUP formulas, etc. The resulting file size generated was 39.4 MB. Is there a way to examine the file to see where the abnormality is that's causing this huge size? when I try to save the 2004 file as a v.2008 file the program either crashes or shows an error message indicating a corruption in the file. I'd like to correct the corruption if possible so as not to have to re-generate the entire file from the ground up.

Peter P.

 

[CyberTaz]

Why did you do the copy/paste in the first place? You need only open the
file with Excel 2008 then Save As in the new format. Try that & see if you
don't get a better result.

 

[Mungo]

the file is probably large because of the vlookup function, especially if the lookup file is in a different folder. You could highlight the whole sheet, then copy and paste values only. this may reduce the file size.

 

[Shane Devenshire]

Hi,

If you did a copy and paste Excel probably modified all the local reference
to look back to the file you were copying from. My suggestion is CT's - open
the file directly in 2008, and then do a Save As to the new file format.

Unless you had ten's/hundred's of thousands of VLOOKUP's I wouldn't expect a
file size of 40MB.

I work with files which can have 750,000 formulas, some quite complex, and
the file size is on the order of 20 MB.

Also, I agree Mungo, you should convert unneeded formulas to values - it
reduces filesize and speeds up calculations.