Excel file size limitation


S

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!
 
Ad

Advertisements

T

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.
 
D

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.
 
B

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
 
Ad

Advertisements

J

JLatham

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top