EXCEL 2016 DISPLAY & TAB ISSUES-

Question

I have experienced three serious issues using Excel v. 15.17 on a new MacBookPro running OS10.11.12:

1.  When trying to view cells that are off the screen of my worksheet, neither the right nor bottom scroll bars appear until the worksheet is first scrolled using the arrow keys on my keyboard.  Then the scroll bars appear and function normally.  I have the "scroll bars always" item checked in Finder Preferences.
2.  On several large workbooks with multiple worksheets, I can see the tabs to the underlying worksheets, but the worksheets can not be accessed.  Clicking on the bottom tabs does nothing.  The workbook was created in Excel 2011, and it behaves normally if I move it back to Excel 2011 on my old Mac.
3.  When I hover over the arrows (with a mouse) in the lower left corner of the screen, to select a different worksheet within a workbook, an annoying tip sheet appears and will not go away.  It blocks the view of and access to these navigational arrows.

These issues materially affect the usefulness of Excel 2016.  I can not use it until these bugs are fixed.

Thank you-

Answer 1

Thanks, Bob, for your suggestions.

Regarding #1, the scroll bars don't appear unless one first scrolls off the screen using the arrow keys.  Then they appear and work normally.  I tried "waking up" the scroll bars with the mouse, but had no luck.  I agree, it may be an Apple El Capitan issue.

And thanks for your tip on #3.  I would rather use all of my 15" screen, but this is an acceptable work-around.  However, the right click does not display the dialog you mentioned.  It does nothing.  This might be related to issue #2?

#2 is the killer.  Unless I can access the other worksheets in the workbook, Excel 2016 is useless!

Kent

Answer 2

1. I believe that what you are seeing is an Apple issue, not Excel. Does the cscroll bar appear when you move the cursor to the right side of the Excel window? If so, then this is "by design" and is Apple's new way to show scroll bars.
2. This is strange, I have not seen or heard of this before.
3. This has been reported frequently here. You can solve it by making the window slightly smaller so the dialog falls below the arrows. Secondly, you can right click on the arrow to display a dialog of all sheets in the  workbook. You can then select the sheet from there.

Microsoft is aware of at least 1 and 3. You'll have to keep checking future updates to see if they have been fixed. Use the smiley face in the upper right of the menu bar to tell Microsoft of #2.