Excel file size limitation

[Stew_Katz]

I've got someone trying to work with a 400MB Excel spreadsheet using Office
2007. Excel keeps crashing when trying to modify and then save the file.
Outlook goes into Not Responding mode. The file itself doesn't contain all
that much data, however, it does contain many high-res images cropped to fit
into a cell. The pictures have been compressed, however the file size
doesn't change all that much.

I was under the impression that the PC itself perhaps didn't have enough RAM
memory. Tried working with the file from a PC having 4GB or RAM - same
result. I then tried doing the same from a machine with a clean install of
Windows 7 with 8GB of RAM - Excel still hangs when trying to save the file.

I know there are limits regarding the # of rows/columns in a spreadsheet,
but my question her is, is there some sort of limitation in terms of file
size for Excel.

Thanks for the help!

 

[trip_to_tokyo]

You can check out:-

EXCEL Specifications And Limits

- topic in the EXCEL Help Facility.

There does not appear to be any limit.

Please hit Yes if my comments have helped.

Thanks.

 

[dlw]

Excel doesn't handle images that well. As a company we use it for page
layout and presentation materials (because users are un-willing to learn a
"real" presentation package, but I digress...)
Anyway, it really helps to use photoshop, or something like it, to re-size
them down to the size they will be in the sheet: one, two, three inches wide.
Then insert them into the sheet.

 

[Jim Thomlinson]

One place to look...

http://www.decisionmodels.com/memlimits.htm

 

[Billns]

Excel doesn't handle images that well. As a company we use it for page
layout and presentation materials (because users are un-willing to learn a
"real" presentation package, but I digress...)
Anyway, it really helps to use photoshop, or something like it, to re-size
them down to the size they will be in the sheet: one, two, three inches wide.
Then insert them into the sheet.

Even better to use a different program completely -- Adobe's InDesign
would probably fit the bill. Or perhaps even MS Publisher.

One way to work with multiple graphics in Excel is to use hyperlinks.
Put a link to the graphic file in a cell. When the user clicks on that
cell the graphic is displayed separately.

Bill

 

[JLatham]

Isn't it good to see that Charles finally got the MVP recognition he's
deserved for so long?