ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What is the maximum file size Excel can save? (https://www.excelbanter.com/excel-discussion-misc-queries/90506-what-maximum-file-size-excel-can-save.html)

IDBS

What is the maximum file size Excel can save?
 
I can export a file that is 27.1MB into Excel and view it but I cannot seem
to save it. Is there a difference in the maximum size of a file size that
can be opened in Excel and the size of files that can be saved?

Daniel CHEN

What is the maximum file size Excel can save?
 
File size should not be a problem. I can save and edit an excel file of 70
M.
How many rows/columns of data do you have?

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"IDBS" wrote in message
...
I can export a file that is 27.1MB into Excel and view it but I cannot
seem
to save it. Is there a difference in the maximum size of a file size that
can be opened in Excel and the size of files that can be saved?




Don Guillett

What is the maximum file size Excel can save?
 
I really don't know but would imagine the only limit is memory. But, I'll
bet your file is overloaded and really doesn't need to be that big.
http://www.contextures.com/xlfaqApp.html#Unused

--
Don Guillett
SalesAid Software

"IDBS" wrote in message
...
I can export a file that is 27.1MB into Excel and view it but I cannot
seem
to save it. Is there a difference in the maximum size of a file size that
can be opened in Excel and the size of files that can be saved?




IDBS

What is the maximum file size Excel can save?
 
Thanks for the replies guys. The file I am using is well within the row and
column limits (577 rows, 12 columns). I understand that current versions of
Excel will have their own memory allocations and will not use more than 1GB
of RAM regardless of the PC's specifications. The reason the file I am using
is so big is that it contains a large amount of graphical data. Any more
suggestions?



"Don Guillett" wrote:

I really don't know but would imagine the only limit is memory. But, I'll
bet your file is overloaded and really doesn't need to be that big.
http://www.contextures.com/xlfaqApp.html#Unused

--
Don Guillett
SalesAid Software

"IDBS" wrote in message
...
I can export a file that is 27.1MB into Excel and view it but I cannot
seem
to save it. Is there a difference in the maximum size of a file size that
can be opened in Excel and the size of files that can be saved?






All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com