7 Replies Latest reply on Jun 9, 2009 2:02 AM by Michaelp

    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