Once you get to a million just start a new one and create a “master” spreadsheet that uses power query to append them all. Problem solved ;)

Don’t tell anyone but I actually do this.