Dears,

A user of Excel 2007 has a weird issue (windows XP, laptop + external monitor):

a sheet containing different formulas behaves as follows:

- when sheet is opened on the internal monitor, content of the cells is visible in cells and on the formula bar.

- when sheet is moved to the external monitor, content of the cells is visible in cells but invisible on the formula bar (empty).

- when the sheet is restored down on the external monitor, content of the cells is visible on the cells but on the formula bar the content is displayed as a formula.

Any tips concerning this issue?

Hi,

Which mode did you use to content the laptop and external monitor?  Copy-Mode or Expanded-Mode?

Did your mean that the formula disappeared from the formula bar in external monitor?

I recommend we choose another file to test and use Copy-Mode.

Regards,

George Zhao
TechNet Community Support