After using Find, typed values do not display until switching sheets.

[rossi789]

Hi,

I have been passed a problem by a colleague. They use Find to locate a cell, then enter a value alongside this cell but these values do not display in the cell. They do display in the formula bar.

The values appear when switching to another sheet and back again.

This only seems to occur after using Find. After switching sheets values can be typed and appear immediately but only until Find is used again.

The problem is limited to a single workbook. Any suggestions?

Thanks in advance.

 

[Smitty]

Here's a link to the Office Insiders program.

 

[rossi789]

I still do not have a solution for this problem but I have noticed that the behaviour seems to occur when using Freeze Panes. The workbook is ordinarily frozen on column Y.

Unfreezing "refreshes" the page and any typed figures appear. Following the same process, using Find then typing, the behaviour does not occur. Very peculiar.