Excel (365 and 2021 LTSC) Data Input Problem

Hi,

I didn't have this problem in Office 2013 but in Office 2021 (and 365) version(s), entering and editing cell data is too slow. Just one of my sheets which contains "General" and "Text" data type has this problem (average 50 words in one cell). Other sheets have no problem, they have not many data in one cell and have different data type.

After deleting Office settings "RegKey", it is OK! But it comes back after opening the file for 3 or 5 times! In Excel "Safe Mode" it is always normal (I have no add-on or macro in my Excel doc).

I have disabled "Hardware Acceleration", changed to "Performance" mode, disable "Automatic Calculation", uninstall and reinstall Office, save the sheet as a single "Binary" and as a "New Excel" doc, but nothing!

atinfo said:

Hi,

I didn't have this problem in Office 2013 but in Office 2021 (and 365) version(s), entering and editing cell data is too slow. Just one of my sheets which contains "General" and "Text" data type has this problem (average 50 words in one cell). Other sheets have no problem, they have not many data in one cell and have different data type.

After deleting Office settings "RegKey", it is OK! But it comes back after opening the file for 3 or 5 times! In Excel "Safe Mode" it is always normal (I have no add-on or macro in my Excel doc).

I have disabled "Hardware Acceleration", changed to "Performance" mode, disable "Automatic Calculation", uninstall and reinstall Office, save the sheet as a single "Binary" and as a "New Excel" doc, but nothing!

Click to expand...

I'll have a look but I just can't say I've ever had a performance problem from EXCEL unless it's been me using a VBA macro with hideously inefficient code attempting to retrieve data from a huge database (itself poorly constructed).

I've used excel for years and can't ever remember people complaining how inefficient or slow it was -- unless their whole computers were incredibly under 'Speccd to begin with.

Good test is to plot the temperature distribution down a 25 CM long 3 cm diameter steel rod after one end is heated to 100 deg C. -- you need some "calculus " and knowlege in solving differential equations -- you just plot the approx result, then recursively do it again improving accuracy each time until you get the precision you need. That really tests EXCEL to its limit but works brilliantly even on a modest laptop with a gen 6 i5 core duo CPU.

Have fun with that one !!!!!

Cheers
jimbo