The tool rerun after removing sorting


Hi Im new this tool - Im trying to check index status of list of 1000+ URL.

After checking - when I try to manipulate the data (remove sorting/filter for example), the formula rerun again.

I have tried few times and the process get repeating.

Is there a way to stop the formula automatic rerun when I manipulate the data?

I am using insert formula method to check index.

Please advice


Hi Eric,

I usually copy paste the results as values to avoid this. It is built into Excel to recalculate if you change sorting or edit a cell etc.

You can try to disable automatic recalculation if you really want to keep the formulas. This setting is found under Formulas tab -> Calculation Options.

1 Like

thanks - works wonder for me.

1 Like