If you would rather not turn off automatic calculation, you can try using this feature (if you have multiple processors in your computer) to reduce calculation time.
To enable the multi-threading feature, click the FILE tab and select Options to open the Excel Options dialog box, as mentioned earlier. Scroll down to the Formulas section and select the Enable multi-threaded calculation check box so there is a check mark in the box.
Test out different combinations of the Automatic Calculation and Multi-Threaded features to see what works best for you on your computer.
Imagine if you could save yourself an hour a week (or maybe more) by automating the process of updating charts and graphs. There’s an Excel technique for that, so put your geeking cap on, and let’s get to it. Before you know it, you’re throwing away an hour here and an hour there – or more, depending on how much of your workload is focused on reporting.
You can specify manually how many threads to use, or you can tell Excel to Use all processors on this computer.
If you have other programs running on your computer, you may not want to use all the processors on your computers to recalculate the formulas in your Excel spreadsheets.
While the formulas are being recalculated, the mouse pointer changes to an hourglass and you can’t make any changes to the worksheet.
I tested the issue out on a couple of new speedsheets (both saved on the same shared drive) and it's still happening.
We will show you how to turn on this option later in this article.
To disable the automatic calculation feature, open Excel and click the FILE tab. On the Excel Options dialog box, click Formulas in the menu on the left.
Not sure if its just my computer yet, currently testing the issue with different computers.
This article describes how to display live, updating data from a desktop Excel spreadsheet in a website without any HTML or coding required. You will need an ipushpull account, which is quick to set up. The ipushpull Word Press plugin lets you embed ipushpull pages in your site.