Stop relying on manual clicks and clunky code—let Excel refresh your queries automatically.
If Excel freezes when deleting rows or columns, identify the possible causes and then resolve the issue. Turn off Auto Save, disable COM Add-ins, etc.