Showing posts with label read only. Show all posts
Showing posts with label read only. Show all posts

Sunday, February 3, 2013

Excel opens in Read-Only after upgrading to Windows 8 with Office 2010

Issue:
--------------
After upgrading your Client machine to Windows 8 OS with Office 2010 + SP1. Excel Sheets from SharePoint sites which open on Client Application for editing, open up as 'Read-Only' Mode.

Workaround:
-----------------------
On the Windows 8 Client machine create the below registry key. This is Client machine issue, NOT SharePoint Server related. 
1. Open regedit.exe
2. Naviagate to following key:
[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\14.0\Common\Internet]
"FSSHTTPOff" = dword:0000001
3. Click Edit Menu -> New -> DWORD with name of "FSSHTTPOff" (without quotes)
4. Click on "FSSHTTPOff" and enter value of 1
5. Close any Office Applications and browser sessions
6. Try to repro the problem

Thursday, December 11, 2008

Files opens as Read Only after Check-out

Note:- Please take precautionary steps before applying the below steps. Backup your registry.

Issue:- Files will open as Read-Only after checking Out a document in SharePoint and trying to Edit it.

Environment:- XP + Office 2003 or Vista + Office 2007

Follow the below steps to resolve the issue.
---------------------------------------------------
1.) Search for oledb32.dll on the workstation and make sure it exists in this location. The default location is c:\program files\common files\system\ole db\oledb32.dll

2) Copy and paste the information below to Notepad and save as a .reg file. This will correct the entries in the Registry that are probably missing.

===========================================================
REGEDIT4
[HKEY_CLASSES_ROOT\CLSID\{FF151822-B0BF-11D1-A80D-000000000000}]@="Microsoft OLE DB Root Binder for Internet Publishing"

[HKEY_CLASSES_ROOT\CLSID\{FF151822-B0BF-11D1-A80D-000000000000}\InprocServer32]@="C:\\Program Files\\Common Files\\system\\ole db\\oledb32.dll""ThreadingModel"="Both"

[HKEY_CLASSES_ROOT\CLSID\{FF151822-B0BF-11D1-A80D-000000000000}\OLE DB Binder]@="Microsoft OLE DB Root Binder"

[HKEY_CLASSES_ROOT\CLSID\{FF151822-B0BF-11D1-A80D-000000000000}\ProgID]@="MSDAURL.Binder.1"

[HKEY_CLASSES_ROOT\CLSID\{FF151822-B0BF-11D1-A80D-000000000000}\VersionIndependentProgID]@="MSDAURL.Binder"

[HKEY_CLASSES_ROOT\MSDAURL.Binder.1]@="Microsoft OLE DB Root Binder for Internet Publishing"

[HKEY_CLASSES_ROOT\MSDAURL.Binder.1\CLSID]@="{FF151822-B0BF-11D1-A80D-000000000000}"

[HKEY_CLASSES_ROOT\MSDAURL.Binder]@="Microsoft OLE DB Root Binder for Internet Publishing"

[HKEY_CLASSES_ROOT\MSDAURL.Binder\CLSID]@="{FF151822-B0BF-11D1-A80D-000000000000}"

[HKEY_CLASSES_ROOT\MSDAURL.Binder\CurVer]@="MSDAURL.Binder.1"

===========================================================

3) From Start->Run, type Regsvr32.exe "[Drive]:\Program Files\Common Files\System\OLE DB\MSDAIPP.DLL"

4) Test and see if the issue is resolved.

Total Pageviews