Infinite blank rows keep coming back

[ggirf14]

How can I delete blank rows in Excel.
It keeps coming back to 1048576 rows when I have only have data down to line 548
Using CTRL + End brings me to R1048576
and Table range from A1 to R1000
I have done the following:
1- Selecting all cells from A1001 to R1048576 and delete the cells content + Save, close and reopen the document
2- Selecting all rows from 1001 to 1048576 + Save, close and reopen the document
3- Tested a few VBA codes.

Yes I do have formulas using the complete columns in a few formulas but I am sure I used similar formulas without causing such an issue.
I'm willing to change the file extension from xlsx to zip to dive in the folder structure to edit what would be needed but the documentation on this is rare.
Is there a list of events / conditions to check that cause this issue?

 

[Fluff]

Have a look at this thread & see if anything helps Reducing workbook file size

 

[ggirf14]

Have a look at this thread & see if anything helps Reducing workbook file size

Thanks for the lead and quick reply.
What have worked in my current situation was (((( I love excel )))) what is on line 4 of the link you provided "inspired by a previous post from @Fluff that suggested to alter the row heights of the sheet."
I simply did it manually

1- Select all rows to delete
2- Resize row height of the selected rows
3- Delete the selected rows
4- Save the file.

The last cell is now R1000, scroll bar works normally for a file with only 1000 lines and the file size went from 3 Mb down to 365kb.
The file was starting to be sluggish and is now reacting very crisp / fast like a healthy file should be.

 

[Fluff]

Glad you sorted it & thanks for the feedback.