cancel
Showing results for 
Search instead for 
Did you mean: 

VirusScan Enterprise 8.5.0i dramatically slow down Excel VBA cells access

Hi,
My company is using VirusScan Enterprise 8.5.0i (Engine 5301.4018, DAT 5601.0000), I wrote a simple test code and find that Excel 2007 runs very slow when the virus scanner turned on when VBA code is doing cell by cell access. Same code run very fast in excel 2003 and excel 2007 without virus scanner turned on.
I do not have any permission to change any setting in virus scanner, does anyone know if it is Mcafee bug or there is anyway to work around it?

Thanks

Public Function test()

Dim wsSheet2 As Worksheet
Dim i As Integer
Dim j As Integer
Set wsSheet2 = Worksheets("sheet2")
wsSheet2.Cells.ClearContents
Dim startTime As Date
Dim endTime As Date
startTime = Now
For i = 1 To 100
For j = 1 To 100
wsSheet2.Cells(i, j) = "1"
Next
Next
endTime = Now
Worksheets("sheet1").Cells(1, 1) = startTime & " to " & endTime
End Function
I noticed that the CPU of excel.exe process shoot up to 100% when the above code runs.
If I keep the service on but turn off on-access scan, it has the same problem. The only time the excel file runs fast is turn off the mcafee shield service.

Thanks,
TF

Posts merged and moved to the correct area - MOD
7 Replies
sco_at
Level 9
Report Inappropriate Content
Message 2 of 8

RE: VirusScan Enterprise 8.5.0i dramatically slow down Excel VBA cells access

I have the same experience with a MS Word App. Slow when mcshield is running or paused, fast when mcshield stopped. What is mcshield doing when it is paused??

Bernhard
Highlighted

RE: VirusScan Enterprise 8.5.0i dramatically slow down Excel VBA cells access

I found the problem/solution for my case, and I believe the following happened.

MS Excel is trying to access a registry key that does not exist (for each cell update), and it is opening a read/write lock to the registry. I believed Mcafee adds whole bunch of Event Listener when there is a write request to registry, and those listener are still on even the on-access protection is turned off. So for each cell update, MS Excel do a read/write lock to registry and it triggered the Mcafee event listener that probably cost 1ms. So updating 10k cells last 10 seconds.

I don't know how does it apply to your case but I simply add the registry back and everything is now working fine.

Good luck.

sco_at
Level 9
Report Inappropriate Content
Message 4 of 8

RE: VirusScan Enterprise 8.5.0i dramatically slow down Excel VBA cells access

How did you check for the missing registry key? Did this show up in regmon?
DV27
Level 7
Report Inappropriate Content
Message 5 of 8

RE: VirusScan Enterprise 8.5.0i dramatically slow down Excel VBA cells access

1) have you got ScriptScan on?

2) have you updated to the latest version of Windows Scripting Host?
sco_at
Level 9
Report Inappropriate Content
Message 6 of 8

RE: VirusScan Enterprise 8.5.0i dramatically slow down Excel VBA cells access

1) No.
2) Will check.

RE: VirusScan Enterprise 8.5.0i dramatically slow down Excel VBA cells access

For the excel problem I had.
Problem exists regardless of ScriptScan on or off.
I have latest windows scripting host

Microsoft (R) Windows Script Host Version 5.7
Copyright (C) Microsoft Corporation. All rights reserved.


I used processmon by the way.

RE: VirusScan Enterprise 8.5.0i dramatically slow down Excel VBA cells access

Hello,

which was the missing registration key in this case?

Kind regards



Michael
More McAfee Tools to Help You
  • Subscription Service Notification (SNS)
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • eSupport: Policy Orchestrator
  • Community Help Hub

      New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

    • Find Forum FAQs
    • Learn How to Earn Badges
    • Ask for Help
    Go to Community Help

    Join the Community

      Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

    • Get helpful solutions from McAfee experts.
    • Stay connected to product conversations that matter to you.
    • Participate in product groups led by McAfee employees.
    Join the Community
    Join the Community