Home

Slow copy-down for large simulation model

%3CLINGO-SUB%20id%3D%22lingo-sub-623135%22%20slang%3D%22en-US%22%3ESlow%20copy-down%20for%20large%20simulation%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-623135%22%20slang%3D%22en-US%22%3EI%20have%20been%20developing%20extremely%20large%20spreadsheets%20(%26gt%3B700%20Mb%2C%20now%20approaching%201Gb)%20in%20Excel%2064%20to%20simulate%20mineral%20treatment%20processes.%20I%20successfully%20developed%20one%20large%20spreadsheet%20of%20this%20nature%20late%202018%20and%20had%20few%20issues%20with%20copying%20the%20model%20from%2010%2C000%20rows%20to%20400%2C000%20rows%20(the%20model%20is%20about%20200%20columns%20wide%20and%20each%20row%20represents%20a%20minute%20of%20elapsed%20time).%3CBR%20%2F%3EI%20now%20have%20a%20model%20that%20is%20%26gt%3B1000%20columns%20across%20but%20it%20takes%20forever%20(%26gt%3B18%20hours)%20to%20copy%20the%20model%20from%201000%20rows%20to%2020%2C000%20rows.%20The%20problem%20occurs%20on%20the%20same%20laptop%20used%20to%20develop%20the%20first%20model%20(gen%205%20i7%20chip%20with%2016%20Gb%20RAM)%20and%20on%20my%20new%20laptop%20(gen%208%20i7%20with%2032%20Gb%20RAM).%20Is%20there%20a%20known%20problem%20with%20mega-spreadsheets%20when%20they%20get%20too%20wide%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-623135%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-623244%22%20slang%3D%22en-US%22%3ERe%3A%20Slow%20copy-down%20for%20large%20simulation%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-623244%22%20slang%3D%22en-US%22%3ECheck%20the%20presence%20of%20volatile%20functions%20and%20array%20formulas%20that%20make%20your%20spreadsheet%20slow.%20Avoid%20them%20if%20possible.%3C%2FLINGO-BODY%3E
DD-Wood
Occasional Visitor
I have been developing extremely large spreadsheets (>700 Mb, now approaching 1Gb) in Excel 64 to simulate mineral treatment processes. I successfully developed one large spreadsheet of this nature late 2018 and had few issues with copying the model from 10,000 rows to 400,000 rows (the model is about 200 columns wide and each row represents a minute of elapsed time).
I now have a model that is >1000 columns across but it takes forever (>18 hours) to copy the model from 1000 rows to 20,000 rows. The problem occurs on the same laptop used to develop the first model (gen 5 i7 chip with 16 Gb RAM) and on my new laptop (gen 8 i7 with 32 Gb RAM). Is there a known problem with mega-spreadsheets when they get too wide?
1 Reply
Check the presence of volatile functions and array formulas that make your spreadsheet slow. Avoid them if possible.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies