MS Excel is slow on VDI

|
  • 144
  • 8

Issue Description

Customer feedback that using Microsoft Excel on VDI is very slow when operating excel files. The excel file contains over 3.5K worth of records.

Error/Warning Information

Performing sort,filter and save will load for few seconds and not responding temporarily.

Handling Process

1. The excel file is fairly small. Less than 5MB.

2. Inside the excel file has over 3K data's on a single sheet and mostly using formulas and calculations.

3. User feedback that the same file is faster when operate on physical machine. The spec of VM and the physical machine are: VM: 4C8G , PC: 2C4G.

4. Open Resource Monitor on the VM, when operating on the Excel file the Excel process obviously consumed high CPU usage and causing the slowness and Not Responding.

5. Looked on forums online and determine that this is normal behaviour on Excel with large data and calculations.

Root Cause

Excel files contains a lot of data and uses formulas for calculation. When user performs sorting and filtering, Excel recalculate the data (which is redundant process since the data is not changed).

Solution

1.Go to Excel options > Formula > Calculation Options. Select 'Manual' and uncheck 'Recalculate workbook before saving'.


2. Now operating the Excel file has no slowdown at all.

Note:
1. Initially user argues that this method is not seems right and causes inconvenience. But as we compared on the physical machine, it uses the same configuration.
2. Tested on physical machine to use 'Automatic' calculation option, there is obvious slowness and not responding.

Suggestions

1. Remember to check the excel file size, content (whether involves alot of formula/calculations).
2. Check turbostat on VMP host and ensure CPU is not underclocked.
3. Compare with physical machine using same version of Excel.
Raza Islam Lv3Posted 04 Jul 2022 19:26
  
Thanks for sharing.
Raza Islam Lv3Posted 18 Jul 2022 20:51
  
Thank you very much for the information.
Naghmana Lv1Posted 19 Aug 2022 19:46
  
Thank you for your information
Faisal P Posted 14 Sep 2022 08:16
  
Thank you very much for the information ...
Faisal P Posted 14 Sep 2022 08:17
  
Nice article ...
Faisal P Posted 14 Sep 2022 08:17
  
Great info ...
Faisal P Posted 14 Sep 2022 08:17
  
Very informative ...
Faisal P Posted 14 Sep 2022 08:18
  
Nice guidance ...

I want to write a case
Doc ID: 6030
Author: Sangfor_Siva
Updated: 2022-06-23 14:28
Version: