HOW TO FIX FILE VIOLATION ERROR IN MICROSOFT EXCEL 2010 - THE VICAMP GROUP

HOW TO FIX FILE VIOLATION ERROR IN MICROSOFT EXCEL 2010
100% WORKING

PROBLEM STATEMENT

"Your changes could not be saved to ' xxxxxx' because of a sharing violation. Try saving to a different file.
Show Help
Ok
…………………………………………………………………………………………………………………………..........................................
The file you are trying to open, xxxxxx, is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?

Yes  No    Help

Yes does not work

No
Your changes could not be saved to 'excel.xlsx', but were saved to a temporary document named 'xxxxxxx'. Close the existing document, then open the temporary document and save it under a new name."

FIX OR SOLUTION

Causes:
There is a security feature in Excel, introduced with Office 2007, which matches the content of the file and the file name extension.
That warning will show up when the security feature is enabled and it detects possible incompatibility between the actual content of the file and the file name extension, which can cause unexpected problems.

 Solution:
The warning can be eliminated by disabling the security feature in Excel through the Registry Editor:
1. Close Excel.
2. Launch the Windows Registry Editor (Windows Start button > Search > REGEDIT.EXE).
3. Navigate to the following subkey:
   HKEY_CURRENT_USER\Software\Microsoft\Office\[OfficeVersionNumber]\Excel\Security
NOTE: The [OfficeVersionNumber] has to match the version number of your installed MS Office.
   [OfficeVersionNumber]
   Office 2003 -> 11.0
   Office 2007 -> 12.0
   Office 2010 -> 14.0
   Office 2013 -> 15.0
4. Craeate a new DWORD value:
   Value name: ExtensionHardening
   Value type: REG_DWORD
   Value data: 1

The following list contains the value data settings that are appropriate for the ExtensionHardening setting:
   0: Do not check the file name extension and the file type, and bypass the function of the warning message.
   1: Check the file name extension and the file type. If they do not match, display the warning message.
   2: Check the file name extension and the file type. If they do not match, do not open the file.

5. Close the Windows Registry Editor and restart your computer
voilaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

BROUGHT TO YOU BY  - THE VICAMP GROUP - www.vicampcreations.weebly.com
0262376308/0243376308