It doesn’t always work especially when switching between sheet with Freeze Panes activated and sheet without Freeze Panes. In order to make it work, we need to move the mouse cursor to the left arrow of the horizontal scroll bar. This will enable horizontal scrolling for all sheets with the same Freeze Panes configuration (frozen or unfrozen) as the current sheet.