Prev: Excel on Different Computers
Next: A link to a collection of tutorials and videos on Data-Applied.
From: Stew_Katz on 9 Apr 2010 14:30
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!
From: trip_to_tokyo on 9 Apr 2010 14:40
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.



"Stew_Katz" wrote:

> 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!
From: dlw on 9 Apr 2010 14:50
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.

"Stew_Katz" wrote:

> 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!
From: Jim Thomlinson on 9 Apr 2010 14:58
One place to look...

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

Jim Thomlinson


"Stew_Katz" wrote:

> 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!
From: Billns on 9 Apr 2010 19:47
On 4/9/2010 11:50 AM, dlw wrote:
> 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
 |  Next  |  Last
Pages: 1 2
Prev: Excel on Different Computers
Next: A link to a collection of tutorials and videos on Data-Applied.