Problem: Over remote desktop connection, memory spikes on host computer to 100% & Excel freezes
Problem does NOT occur when GPU is removed or disabled in hardware manager
Same Problem on two systems (See Specs Below) using Excel Workbook over remote connection.
- Local users on various system platforms have no problems with same workbook.
- Remote user on home system (same used as remote client) has no problems with same workbook.
Problem Description:
Using the scroll wheel only scrolling up and down sheet 1 of the workbook for a few minutes:
- Memory usage climbs quickly and pegs at 100% per Task Manager Performance Tab
- Power Usage freezes at VERY HIGH per Task Manager Performance Tab
- Worksheet becomes non-responsive & unusable
Remote Connection Information:
- Remote connection is via Remote Desktop Connection client through a Sophos VPN to company network.
- CLIENT: Remote side Internet Connection 300 Down / 30 Up
- HOST: Company side Internet Connection 100 Down / 100 Up
Workbook Information (Sheet 1)
- 20 columns/582 rows
- In use without problems for over 6 years by up to 20 users
- 100% Free of Volatile Functions
- No Circular References
- Automatic Calculations set
- File Size is about 4 MB
- Lots of Conditional Formatting, VBA Code
Cures tried with no positive results
- Excel in Safe Mode
- Hardware Acceleration Enabled and Disabled in Excel options
- Multi-Thread calculations Enabled and Disabled in Excel options
- Excel Open & Repair – no issues found
- Remote Session Environment: “Use the hardware default graphics adapter for all Remote Desktop Services sessions” Enabled
- Remote Session Environment: “Use the hardware default graphics adapter for all Remote Desktop Services sessions” Disabled
- Deleted all Macros, and Data in cells – only cell colors & navigation buttons remained
SYSTEM 1
-
Processor AMD Ryzen Threadripper PRO 5955WX 16-Cores 4.00 GHz
-
Installed RAM 32.0 GB (31.9 GB usable)
-
System type 64-bit operating system, x64-based processor
-
Video Card NVIDIA T1000 8GB
-
Disk 1TB SSD
-
Edition Windows 11 Pro
-
Version 21H2
-
Installed on 5/17/2022
-
OS build 22000.708
-
Experience Windows Feature Experience Pack 1000.22000.708.0
-
Microsoft® Excel® for Microsoft 365 MSO (Version 2205 Build 16.0.15225.20172) 64-bit
-
Windows 11 & Office 365 – Set to Automatic Update
SYSTEM 2
-
Processor Intel(R) Core™ i7-7700K CPU @ 4.20GHz 4.20 GHz
-
Installed RAM 32.0 GB (31.9 GB usable)
-
System type 64-bit operating system, x64-based processor
-
Video Card NVIDIA Quadro M4000 8GB
-
Edition Windows 10 Pro
-
Version 21H2
-
Installed on 9/9/2020
-
OS build 19044.1645
-
Experience Windows Feature Experience Pack 120.2212.4170.0
-
Microsoft® Excel® for Microsoft 365 MSO (Version 2205 Build 16.0.15225.20172) 64-bit
-
Windows 10 & Office 365 – Set to Automatic Update