Solved

Microsoft Excel opens slowly when Trend Worry Free/Micro Security Agent is Enabled

Posted on 2013-02-01
4
1,220 Views
Last Modified: 2013-11-22
We recently changed over from McAfee to Trend.  Excel opens slowly on my computer; regardless of opening a file to open Excel, or simply opening the program.

When I disable Trend, Excel opens at normal speed.

I've tried adding an exception to the path of Excel, as well as XLS and XLSX file types.  I've also added it to a trusted program.  No luck.  When I close Trend, Excel opens fine.  Any suggestions?

I think it may be an add-in, however, I am unable to determine the add-in path or extension to exclude.
0
Comment
Question by:spaethg000
  • 3
4 Comments
 
LVL 16

Assisted Solution

by:terencino
terencino earned 500 total points
ID: 38845749
Hi, this was the main reason we moved away from Trend! It is possible the patch or hotfix noted here at Trend might resolve the problem. But probably not.
Worry-Free Business Security (WFBS) 7.0 issues that will be resolved by Critical Patch Build 1370
Before moving away from Trend I had the administrator turn off the scan engine during work hours. It defeated the purpose though so we moved to Panda, then Sophos, and now GFI Managed Antivirus.
Hope that helps
...Terry
0
 

Author Comment

by:spaethg000
ID: 38847825
I saw that link, but that's for version 7.  I'm already on version 8.  I continue to search for a solution.   Thank you though!
0
 

Accepted Solution

by:
spaethg000 earned 0 total points
ID: 38854951
This solution improved Excel performance by 50%:

1. Unload the WFBS Security Agent.
2. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\TmFilter\Parameters\
3. Right-click on Parameters > New >DWORD Value
4. Rename the Binary Value from New Value #1 to ExcelSDT
5. Set value: 64 in Hexadecimal base
6. Check the save result, should display 0x00000064 (100)
7. Reload the Security Agent
8. Wait for 1-2 minutes for setting deploy.
9. Try to save Excel files and check if you have the same issue.

This second registry tweak brought performance levels near or at normal:

1. Unload WFBS Agent
2. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\TmFilter\Parameters\
3. Locate the REG_DWORD --->  AvoidExcelSaveIssue 4. Right-click on it and choose "modify"
5. Change the value from "1" to "0"
6. Reload the Security Agent
7. Wait for 1-2 minutes for setting deploy.
8. Try to save Excel files and check if you have the same issue.
0
 

Author Closing Comment

by:spaethg000
ID: 38872655
My solution solved the issue. :)
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now