I have a spreadsheet that refuses to reset its last used cell even
though I delete all rows between the last row that i want to have in the
usedrange and the last row. Then i go to cell A1 and save the workbook.

While this usually works, in a particular worksheet I am using, this
does not work. Any idea why?