Excel (365 and 2021 LTSC) Data Input Problem


atinfo

Well-known member
Member
VIP
Local time
9:21 AM
Posts
547
OS
Win 11 Enterprise
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!
 
Windows Build/Version
22000.469

My Computer

System One

  • OS
    Win 11 Enterprise
    Computer type
    Laptop
    CPU
    i7
    Hard Drives
    SSD

jimbo45

Well-known member
Power User
VIP
Local time
5:51 AM
Posts
2,275
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
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!

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
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7

Latest Support Threads

Top Bottom