Apply View > Formula Bar at sheet level
The options in the View ribbon, Show group are not consistent in their behaviour. Ruler, Grid lines and Headings are applied at the sheet level. But Formula Bar is applied at the application level, so even other workbooks will show/hide the formula bar according to the setting in the current sheet.
Please apply the View Formula Bar only at sheet level, so that other sheets and workbooks are not affected.
A definite must and, I would imagine, a quick one for MS to resolve. We often need to maximize screen real-estate on non editable report pages, so this would help immensely.
Felipe Costa Gualberto commented
Unfortunately I don't have more votes, but this is a must!