title: how to get rid of "#REF!" error while "importxml" is loading data?
body: <p>Is it possible to get rid of #REF! error in a cell while the formula waits for the data which is being imported from a webpage using importxml function? I would like to not update a cell with new data until new data is imported so the #ref! error wont come up. Thank you.</p>