Excel 2010 document contents not scrolling with scrollbar

This may not be your answer, but it is a situation that I have seen that produces the results you've described.

Look in the macro(s) for the following statement:

Application.ScreenUpdating = False

This tells the Excel GUI interface to not show any changes/updates/anything that is going on. This can be desirable while a macro runs. However, you have to make sure the macro at some point sets this back to true like this:

Application.ScreenUpdating = True

If this is never set back to True, then it produces a situation like you've described.

First search the code for the 'ScreenUpdating' property being set, remove it, and see if that fixes the issue.

If you don't find 'ScreenUpdating' anywhere in the code, then you have some other problem.

Edit: Looks like someone already mentioned screen updating in the comments above.

Here's what you can do.

• First unmaximize the worksheets in your workbook by left-clicking on the small interlocking windows (squares) icon under the red close icon in the top right corner of the Excel window.
• Create a second window for your workbook by right-clicking on the top border of your worksheet (above the row identifiers A, B, etc.). -
• Choose View / Arrange All with the "Vertical" radio button selected and "Windows of active workbook" checked.
• Adjust the vertical boundaries of the two windows so that the left one just shows the "summary" columns you are interested in seeing, and the right one fills the rest of the space.
• In the right window, insert a new column to the right of the columns that are showing in the left window and then scroll the right-side sheet so that this column is the leftmost one showing in the right window. (The new column won't be visible in the left window.)
• Reduce the width of the column to make a narrow margin and then freeze it in place (I'm assuming you will freeze the top row as well).

In the end it will look something like this:

Since the scrolling of the two windows is not synchronized, you will see the summary numbers you are interested in the window on the left, and you will be able to scroll through the rest of the sheet in the right window without problem.