• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

EXCEL Question

H

Helpless

Banned
...anyone know how many rows/columns one can use? Is it memory limited, or is there a cap? ...hate to start adding things only to find I reached the upper limit...
 
fwiw, there's also a maximum size, tho i'm not sure what it is. i was adding loads and loads of graphs to an excel doc and it eventually said something to the tune of &quot;couldn't create <another object>&quot;. it also would give the error &quot;cannot save document&quot; when trying to save it, unless i removed some graphs.
 
Thank you both...will keep that in mind...at 37K +/- now, but was hoping to paste about 10 more data sets into the mix🙂 guess I'll break them down a bit into a half dozen seperate files, thanks.
 
Each sheet is limited to the 65536 column/row each way. You can have multiple sheets in a single Excel file. The default is 3 sheets in Office 97 and later.

I have not run into problems with actual file sizes, as I have seen some over 100MB in size at work. Takes a while to load though.
 


<< Each sheet is limited to the 65536 column/row each way >>



Andy --

Correct me if I'm wrong, but I believe you are still limited to 256 columns in Office 2000.
 
Argh.....sorry, you guys are right....it's 256 columns and 65536 rows.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top