At times unable to enter data in a cell

[vij]

Hi,

While working on a Excel sheet in Windows 10 (Office365), I suddenly cannot enter any data in ANY cell. The problem is resolved when I click on any any other sheet and then come back to the original sheet. Moving to the next cell the issue comes up again at times.

How do I resolve this.

Vij

 

[Yongle]

Does the workbook contain any vba ?
Is the worksheet protected in any way ?
Does this behaviour only happen in the ONE workbook ?
Was the workbook created in 365 or in earlier version of Excel ?
Do any cell formulas in any sheet contain links to other workbooks ?
Does the worksheet contain any array formulas ?
Is the behaviour identical when calculations are set to manual ? (see Formula Tab, Calculation options)

 

[vij]

My answers in Bold alongside.
Does the workbook contain any vba ? No
Is the worksheet protected in any way ? No
Does this behaviour only happen in the ONE workbook ? No, at random in any workbook
Was the workbook created in 365 or in earlier version of Excel ? In 365
Do any cell formulas in any sheet contain links to other workbooks ? No
Does the worksheet contain any array formulas ? No
Is the behaviour identical when calculations are set to manual ? (see Formula Tab, Calculation options) Yes

 

[offthelip]

Have you tried working offline? I know that office 365 can cause delays in all sorts of operations , presumably while it is trying to synchronise

 

[Yongle]

My thoughts are similar to @offthelip

Are workbooks being saved to OneDrive ?
Set autosave to OFF