ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Spreadsheet size... (https://www.excelbanter.com/excel-discussion-misc-queries/134420-spreadsheet-size.html)

Dennis1188

Spreadsheet size...
 
Just looking for opinions....

I have a 3 meg spreadsheet (30 col x 2000 rows) with many, many formulas. I
use excel 2000 and would like to know if a file this size may be approaching
excel limits.


Dave F

Spreadsheet size...
 
XL 2000 has a size limit of 255 columns and 65,000 rows.
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Dennis1188" wrote:

Just looking for opinions....

I have a 3 meg spreadsheet (30 col x 2000 rows) with many, many formulas. I
use excel 2000 and would like to know if a file this size may be approaching
excel limits.


Vergel Adriano

Spreadsheet size...
 
I have worked with much larger files with many, many formulas as well...

Note that there are limitations imposed by the computer such as available
memory and hard disk space.


"Dennis1188" wrote:

Just looking for opinions....

I have a 3 meg spreadsheet (30 col x 2000 rows) with many, many formulas. I
use excel 2000 and would like to know if a file this size may be approaching
excel limits.


Francois via OfficeKB.com

Spreadsheet size...
 
Dennis1188 wrote:
Just looking for opinions....

I have a 3 meg spreadsheet (30 col x 2000 rows) with many, many formulas. I
use excel 2000 and would like to know if a file this size may be approaching
excel limits.


Why not try adding a few more sheets & formulas just to see if you hid some
sort of barrier..then at least you will know what you could expect in your
terms.

I use spreadsheets up to 60MBs with many complex formulas no problems
but there are many things that could affect your situation.

--
Message posted via http://www.officekb.com



All times are GMT +1. The time now is 04:06 PM.

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