Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
IDBS
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Daniel CHEN
 
Posts: n/a
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default 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?



  #4   Report Post  
Posted to microsoft.public.excel.misc
IDBS
 
Posts: n/a
Default 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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to open excel file and when view the file size show as 1 KB Kamal Siva Excel Discussion (Misc queries) 1 March 7th 06 03:23 AM
Excel Maximum size ? Gustav Excel Discussion (Misc queries) 1 March 6th 06 03:05 PM
Excel XP: File name in Title Bar not changed after Save As... Dominic Excel Discussion (Misc queries) 9 August 1st 05 12:58 PM
Large Excel file size caused by a bug ? I really tried everything Anik Excel Discussion (Misc queries) 5 March 16th 05 06:19 PM
Excel file size increased Akheel Excel Discussion (Misc queries) 2 January 29th 05 05:18 PM


All times are GMT +1. The time now is 04:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"