My office uses an Excel spreadsheet for logging new documents. Everyone has access, and new lines are added every day.

Excel normally adjusts the scroll range to the data limit, and changes the range whenever new data is added. But on this spreadsheet the scroll range is all available lines--if you drag the scroll bar to its bottom, the spreadsheet shows line 65536.

Others on this forum have suggested macros to limit the scrollable range. I don't want to fix the limits--this is a working data log--but to make it auto-limit as it's supposed to. Any suggestions?