Close

Is there some way to keep marketXLS from updating automatically?

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…

How to Convert a Formula to a Static Value in Excel 2013

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…

My Excel hangs due to too many calculations, and I am not able to do anything until it finishes.

One Comment on “Is there some way to keep marketXLS from updating automatically?

Richard Guardiani
November 25, 2016 at 2:01 am

Going to manual for the spreadsheet seems to be the best option for me. Thank you.

Comments are closed.