Problem entering data

[Alianza]

I'm having a weird problem entering data using excel 365. I have a spreadsheet workbook which resides in a NAS so I can access it from different computers at home. The file is 2,111 KB. All my computers are running Excel 365. The workbook has several worksheets, each containing an excel table of the same structure as all the other worksheets, i.e., same column headings on each table. On one of my computers I have no problems with this file.
On another of my computers I have a problem when trying to enter data. The problem is as follows:
==> I open the file, ==> go to the worksheet on which I need to enter data, ==> go to a specific record (row) and enter data on several cells (so far so good) ==> then I go to the next record on which I need to enter data, when I attempt to enter data on the cells requiring it excel freezes. At this point I have to close excel then re-open the workbook and see that the data I tried to enter when excel froze is there. Now I try to enter the remaining data in that record and find that sometimes it allows me to enter the data and sometimes excel freezes again; in the cases when I can fill in all the data in the record, when I try to enter data in the next record the same thing happens again. I would appreciate any input on this problem, how to solve it, or how to go about finding what causes it. I have uninstalled office 365 on the problem computer and reinstalling it, but this did not solve the problem. Thanks.

 

[arthurbr]

Would you have sheets with lots of volatile functions and/or conditional formatting?
Does the problem stay if you disable automatic calculation ?

 

[Alianza]

I do not have volatile functions (at least I do not think I do); however, I do have conditional formatting. I will try disabling automatic calculation, then I will post a reply again. Thanks.

 

[Alianza]

I checked the automatic recalculation. When I changed it to manual the problem got resolved. Then to see if the problem would persist if I changed the calculations back to automatic, I found that the problem wasn't there anymore. Thank you for your help, this solution will save me a lot of time.

 

[arthurbr]

You're welcome Mark as Solution