I have a workbook where if you press Ctrl+End, Excel will highlight MT1048576 as the last used cell when actually the last used cell is CZ8669. I know that formatting and formulas in cells "count" as being used but I have cleared all formatting and formulas in the rows below 8669 and it didn't help. I also tried the trick below but it didn't help either. Does anyone know what's going on?
Because of the problem the workbook is too large to attach here so here is a download link.