Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file size limitation
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file size limitation
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file size limitation
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file size limitation
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file size limitation
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file size limitation
Isn't it good to see that Charles finally got the MVP recognition he's
deserved for so long? "Jim Thomlinson" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file limitation workspace | Excel Discussion (Misc queries) | |||
Excel Chart Series Values Property Size Limitation | Charts and Charting in Excel | |||
Limitation to length of Add-In description causes add-in manager to report the add-in file missing. | Excel Discussion (Misc queries) | |||
Unusual File Size in Excel file | Excel Discussion (Misc queries) | |||
Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) |