Forums
New posts
Search forums
What's new
New posts
Latest activity
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Audio and Video Talk
Computers & Networking
Excel Hanging
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Help Support AVForums:
This site may earn a commission from merchant affiliate links, including eBay, Amazon, and others.
Message
<blockquote data-quote="Skookum" data-source="post: 1164756" data-attributes="member: 21551"><p>Late to the game, but some further ideas maybe worth considering:</p><p></p><p>1. Save the workbook as an XLSB - this should improve open, save and storage used - i don't expect any calculation improvements</p><p>2. Previously recommended and a little additional effort but probably worth it - split the workbook into separate annual workbooks with month 1 being values not calculated.</p><p>3. You can also set it to recalculate manually rather than auto, but this can be dangerous because you need to keep track of when last you refreshed the calcs.</p><p></p><p>FYI - 20Gb RAM isn't huge anymore - I'd say 32GB DDR5 is the minimum having a RAM speed of 6Ghz. Also, if you're using a mobile processor and RAM they are also typically de-rated vs the desktop brethren to save power at the expense of performance. I think CPU single thread performance plays a role here since each value is dependent on the last and computationally cant happen in parallel.</p><p></p><p>Keen to hear how things go.</p></blockquote><p></p>
[QUOTE="Skookum, post: 1164756, member: 21551"] Late to the game, but some further ideas maybe worth considering: 1. Save the workbook as an XLSB - this should improve open, save and storage used - i don't expect any calculation improvements 2. Previously recommended and a little additional effort but probably worth it - split the workbook into separate annual workbooks with month 1 being values not calculated. 3. You can also set it to recalculate manually rather than auto, but this can be dangerous because you need to keep track of when last you refreshed the calcs. FYI - 20Gb RAM isn't huge anymore - I'd say 32GB DDR5 is the minimum having a RAM speed of 6Ghz. Also, if you're using a mobile processor and RAM they are also typically de-rated vs the desktop brethren to save power at the expense of performance. I think CPU single thread performance plays a role here since each value is dependent on the last and computationally cant happen in parallel. Keen to hear how things go. [/QUOTE]
Insert quotes…
Verification
Post reply
Audio and Video Talk
Computers & Networking
Excel Hanging
Top
