Hello asaini,

If you have copied formulas down to row 30000, Excel will mark your used range to this point, even if the formulas don't show anything. Aside from removing the unused formulas and saving the worksheet, I don't know of any other way to reset the used range.

Sincerely,
Leith Ross