MarketXLS tries to update everything whenever the sheet recalculates (whenever I change something on the sheet) – and that takes a long time. It’s very cumbersome. Is there anyway to completely block marketXLS from updating automatically?
MarketXLS functions work just like normal Excel functions, if you have a large spreadsheet with all the formulas in there, every time you do operations like sorting/filtering etc, marketXLS functions will automatically calculate and go to the servers to get new information.
This sometimes have impact on usability on Excel sheets. To solve this issue it is best to copy and paste all the Formula results as Values once you have got the data. A lot of information does not change frequently like close price of a specefic day in past will always be the same.
So, unless you want the data to be updating continuously (like may be for real time prices) please copy and paste the formula cells as values. The way to do that is shown below…
Copy the cells with formula, paste special them on the same cells as values, so that you see the values in the forumla bar instead of formulas.
Another good option is to turn Excel into Manual Mode as shown below…