Why D5 cell is being ‘#VALUE!’ ?
I was expecting to see D5 to be ‘21’, but cell formula isn’t calculated.
I intend to refresh table data using server side logic (ex: from data to data2),
then I decided to use Clear() to make sure all cells are cleared before setting new values.
My questions would be:
- Is my usage for Clear() correct?
- What is the best coding practice when refreshing table data from server side logic?