Wednesday, May 16, 2012

Get a DLL from the GAC

Steps to Get a DLL From GAC:

- Open command prompt
- type "cd c:\windows\assembly\GAC_MSIL"
- type "dir"
- Look for the name of the dll that you want
- Type "cd{Name of the dll}"
- Type dir
- Type cd TAB
- Type "copy {dllname}.dll {Path where teh file needs to be copied}

You now have the dll.

Fix issues with opening an excel file in SharePoint Office Web Apps


If you have issues opening an excel spreadsheet in office web apps (OWA), please continue to read:

Problem: "This workbook cannot be opened because it is not stored in an Excel Services Application trusted location. To create an Excel Services Application trusted location, contact your system administrator."

Solution: Go to Central Admin - Excel Services Application > Trusted File Locations and the default entry for address https://, Location Type: Microsoft SharePoint Foundation, Trust Children had already been created.




Problem: Unable to open excel sheet

Solution: - Go to central admin - Security - Configure Service Accounts - Select Windows Service - Claims to Windows Token Service - Change the account from Local Service to Farm Account.

- Central Admin - Excel Services Application - Global Settings - File Access Method - Select Process account.