A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
There is no single file size cutoff published in the Microsoft article you linked. Microsoft only says AutoSave can be disabled for some files, especially large files or files stored on SharePoint, so size is a factor, but it is not the only one. I would compare a working file with one that does not work for format and opening method first. Make sure the file is .xlsx, not an older .xls file, and open it from inside Excel through File, Open, then OneDrive or SharePoint, not from File Explorer or a recent list that points to a local C: path. Also check File, Options, Save, and make sure the AutoSave box is ticked, and check that OneDrive sync is not paused and the Microsoft 365 subscription is active. There is no built-in place in Excel that lists the reason for one file, so I would use that comparison to narrow it down, and look at Excel and SharePoint together, not just one side.