Excel 2007 - Document could not be saved because of a sharing violation error fix
Frequently when using Excel 2007 on windows Vista or Windows 7 I get a message saying "document could not be saved because of a sharing violation error". This happens on a standalone PC not connacted to any others and not on a network as well as when accessing a file on a network.
The problem has been linked to Trend Anti Virus which trend have admitted. They have acknowledged that the Excel 2007 xls / xlsx document could not be saved because of a sharing violation error is linked to their software.
After reading up further on this specific problem I have found a work around when working on Excel.
1.Uninstall search option in windows 7, 2.Unload officescan. When I do this I don't get the error on Excel.I need a solution for this as I don't want to do this everytime.
Unfortunately this is known issue for Windows 7. Please try this fix
1st Solution to "Document could not be saved because of a sharing violation error"
1. On the Officescan Management Console. Go to Networked Computers>Client Management.
2. Highlight a machine with the issue.
3. Go to Settings>Real-time Scan Settings.
4. Under User Activity on Files, change the Scan files being to created/modified.
5. Click on Save.
6. Observe if issue will still happen.
If the 1st Solution does not work, do the ff.
1. Open Registry Editor. Please make a backup before doing any changes.
2. Create a DWORD registry entry "UseMapping" under
HKLM\SYSTEM\CurrentControlSet\Services\vsapint\Parameters
3. Set the value to "0" to disable the file mapping.
2nd SOlution to "Document could not be saved because of a sharing violation error"
If you are using Trend OfficeScan 10, Trend have got a hotfix to resolve the problem.
You could request Hotfix 1855 and the updated engine from Trend Micro support to fix this issue. To do this contact their live support at this URL:
https://trendmicro.ehosts.net/netagent/TrendMicro/en-us/tmchatlogin.asp
Please make sure you read all the below infomration regarding this sharing violation hotfix. Below is all the information released by Trend for this hotfix.
Trend Micro, Inc. - Released January 11, 2010
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Trend Micro(TM) OfficeScan(TM) 10.0 Service Pack 1
Hot Fix - Server Build 1855 and Client Module Build 1900
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
NOTICE: This hot fix was developed as a workaround or solution to a
customer-reported problem. As such, this hot fix has received limited
testing and has not been certified as an official product update.
Consequently, THIS HOT FIX IS PROVIDED "AS IS". TREND MICRO MAKES NO
WARRANTY OR PROMISE ABOUT THE OPERATION OR PERFORMANCE OF THIS
HOT FIX NOR DOES IT WARRANT THAT THIS HOT FIX IS ERROR FREE. TO THE
FULLEST EXTENT PERMITTED BY LAW, TREND MICRO DISCLAIMS ALL IMPLIED
AND STATUTORY WARRANTIES, INCLUDING BUT NOT LIMITED TO THE IMPLIED
WARRANTIES OF MERCHANTABILITY, NONINFRINGEMENT AND FITNESS FOR A
PARTICULAR PURPOSE.
Contents
======================================================
1. Overview of this Hot Fix Release
1.1 Files Included in this Release
2. Documentation Set
3. System Requirements
4. Installation/Un-installation
4.1 Installation
4.2 Un-installation
5. Post-installation Configuration
6. Known Issues
7. Release History
8. Contact Information
9. About Trend Micro
10. License Agreement
======================================================
1. Overview of this Hot Fix Release
===========================================================
Note: Install this hot fix before completing any procedure in
this section (see Section 4.1, Installation).
This hot fix resolves the following issue:
Issue: On a Microsoft(TM) Windows(TM) platform, if the
"searchindexer.exe" process holds the access right to the
Microsoft Excel temporary files, then the Excel files
cannot be saved.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Solution: Hot fix 1855 updates the OfficeScan client files to allow
users to bypass the Windows search index process from the
scan engine.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Procedure: To bypass the "searchindexer.exe" process globally:
a. Open the "Ofcscan.ini" file in the "\PCCSRV\" folder
of the OfficeScan server.
b. Under the "Global Setting" section, manually add the
"TmfilterBypassSearchIdx=1" key.
c. Open the OfficeScan server management console and
click "Networked Computers" > "Global Client Settings"
on the main menu to access the "Global Client Settings"
page.
d. Click "Save" to deploy the setting to clients.
After the command is deployed to the client, OfficeScan
adds the following registry entry on the client computer:
HKLM\SYSTEM\CurrentControlSet\Services\tmfilter\Parameters
Key (dword): BypassSearchIdx
Value: 1
Note: Hot fix 1855 requires that the Trend Micro scan engine be
updated to version 9.160.1006 or above before the deployed
registry entry can take effect.
1.1 Files Included in this Release
=========================================================
Module File Name & Build Number
---------------- ------------
NTRtScan.exe
11.0.0.1900 (32/64 bit)
OfcPfwSvc.dll
11.0.0.1900
OfcPfwSvc_64x.dll
11.0.0.1900
TmListen.dll
11.0.0.1900
TmListen.exe
11.0.0.1900 (32/64 bit)
TmListen_64x.dll
11.0.0.1900
TmListenShare.dll
11.0.0.1900
TmListenShare_64x.dll
11.0.0.1900
ieplug.dll
2.80.0.1080
TMBMCLI.dll
2.80.0.1080
TMBMSRV.exe
2.80.0.1080
tmcomeng.dll
2.80.0.1080
TmEngDrv.dll
2.80.0.1080
TMPEM.dll
2.80.0.1080
tmwlutil.dll
2.80.0.1080
ClnPack_files.xml
2. Documentation Set
===========================================================
o Readme.txt -- basic installation, known issues, release history
and contact information
o Electronic versions of the printed manuals are available at:
http://www.trendmicro.com/download
3. System Requirements
===========================================================
Install OfficeScan 10.0 Service Pack 1 before installing this hot
fix.
4. Installation/Un-installation
===========================================================
4.1 Installation
========================================================
To install this hot fix:
1. Install OfficeScan 10.0 Service Pack 1. If this has been installed
previously, proceed with the next step.
2. Copy the hot fix executable file to a temporary folder,
for example, "C:\temp".
3. Double-click the file. The modules are automatically copied to
the correct destination.
This hot fix installation package automatically rolls back the
OfficeScan server to its previous configuration if there are problems
during installation.
If you encounter problems after installation, do a manual rollback.
4.2 Un-installation
========================================================
To manually roll back to its previous configuration:
1. Locate the backup folder that the hot fix package created in the
"\PCCSRV\Backup\Hotfix_B1855" directory.
2. Copy the backup modules to the original folders.
5. Post-installation Configuration
===========================================================
No post-installation steps are required.
Note: Trend Micro recommends that you update your scan engine and
virus pattern files immediately after installing this hot fix.
6. Known Issues
===========================================================
There are no known issues for this hot fix release.
7. Release History
===========================================================
Visit the following Web site for more information about updates
to this product:
http://www.trendmicro.com/download
8. Contact Information
===========================================================
A license to the Trend Micro software usually includes the right to
product updates, pattern file updates, and basic technical support
for one (1) year from the date of purchase only. After the first
year, Maintenance must be renewed on an annual basis at Trend Micro's
then-current Maintenance fees.
You can contact Trend Micro via fax, phone, and email, or visit us
at:
http://www.trendmicro.com
Evaluation copies of Trend Micro products can be downloaded from our
Web site.
Global Mailing Address/Telephone numbers
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
For global contact information in the Asia/Pacific region, Australia
and New Zealand, Europe, Latin America, and Canada, refer to:
http://www.trendmicro.com/en/about/overview.htm
The Trend Micro "About Us" screen displays. Click the appropriate
link in the "Contact Us" section of the screen.
Note: This information is subject to change without notice.
9. About Trend Micro
===========================================================
Trend Micro, Inc. provides virus protection, anti-spam, and
content-filtering security products and services. Trend Micro allows
companies worldwide to stop viruses and other malicious code from a
central point before they can reach the desktop.
Copyright 2010, Trend Micro Incorporated. All rights reserved.
Trend Micro, the t-ball logo, and OfficeScan are trademarks of
Trend Micro Incorporated and are registered in some jurisdictions.
All other marks are the trademarks or registered trademarks of
their respective companies.
10. License Agreement
===========================================================
Information about your license agreement with Trend Micro can be
viewed at:
http://us.trendmicro.com/us/about/company/user_license_agreements/
Third-party licensing agreements can be viewed:
- By selecting the "About" option in the application user
interface
- By referring to the "Legal" page of the Getting Started Guide or
Administrator's Guide
|
