How to disable cell refresh in google sheets?

Question

XPath

There is a table, in each line there are 3 importxml formulas, on line 6 the table began to update data in cells that had already been loaded before and hang on Loading or #N / ​​A (even though I set it to update when changing in the settings), so here's how to make the table imported data only 1 time and did not update them beyond the limits?

Answer 1

I think that in this case, if you do not need to constantly update the data, it is better to use a script that can implement such functionality.