Excel thinks that the last used row in Sheet1 is 1,048,576 ! Can somebody fix that?

Hello Adriana,
I cannot verify that. I see the last row for sheet1 is 1,048,576 as it should be

Karen Falandays

Thanks !

I cannot verify that. I see the last row for sheet1 is 1,048,576 as it should be

She's referring to the last used row. The last row with any real data is at around 8000. I believe it's the red border formatting of columns like JA that makes Excel think that the last used row is1,048,576

:)

Martin nailed it.  The "last row used" is part of the "UsedRange" property of a worksheet.  Excel uses both data and formatting such as cell borders and coloring to determine the extent of the "usedrange".   Its a common rookie mistake to select an entire column (or row) and apply formatting.  Once you've done that, your used range is the last row of the worksheet.

I removed the red border formatting of all the "long" columns but Excel still thinks the last used row is 1045876!
29222879.xlsb

Mark Edwards 

Thanks !!

the file is still large that you recommend

I don't have enough free memory to do it but if someone could copy sheet1 to a new workbook I think that sheet1 in that workbook would be smaller.

ok 

do you recommend move all the  sheets to a new workbook ?

Yes. Make sure you copy it from the 29222879.xlsb workbook that I attached.

ok im working that  now

2021822_4.xlsx.xlsm

here !

here !!
2021822_4_1.xlsm

I was able to delete the vast majority of the empty rows at the end of Sheet1 and the last used row is now 7500 rather than 1,048,576. Surprisingly to me the size of the workbook was only reduced by about 10%, but it should be faster to work with.
29222879a.xlsb

Great Job !!

 but i miss the navigations buttons and others in the TOP column A to

i did

but need the buttons in the top to work with
29222879a.xlsb

do not use this is not saved

here saved
after repair   
29222879aa.xlsb

I'm sorry but I still can't open the repaired file so I guess you'll need to use the 29222829c.xlsb workbook.

ok

Great Job !