Excel usedrange not updating dating a guy with no kids
If you place some data in a remote location of your spreadsheet and later delete that data Excel retains a memory of the last cell in use even though it is no longer in use. This is the convergence of the highest row in use and the highest column in use (or the memory of such).
using Though this page is mainly oriented to XL95, it appears my Last Cell problems XL95 have been fixed or almost eliminated with maintenance.
When entering numerical data in Excel, it helps to format it according to the type of data it is. percentage, currency, date, or text—helps drive consistency and accuracy in displaying and working with your data.
If you know from the get go what format your data should be in, it’s fairly simple to choose a number format for the entire column before entering your data.
If you have problems with it you can use the Get Save As File Name example on this page as a workeround.