Excel for the Mac - Formulas cannot be seen in formula bar unless you select the text

[JimDandy]

On my Mac (and others I've shared the file with) I have a template where all the formulas are visible, they are not hidden, yet when I select a cell I cannot see the formula or text in the formula bar unless I shift-drag or highlight the formula. In the attachment you can see that the text field has an address but in the formula bar I can only see the portion of the text when I've highlighted it.

The only other thing that allows the formula to be visible is if you click in the address bar and the formula references cells on that page. Otherwise I need to highlight the formula or text to see what's there.

This is an issue on every page of this file.