Tag Archives: excel

Error while opening Excel in Sharepoint2010

3 Feb

If you get error

‘Unable to process the request. Wait a few miniutes and try performing this operation again”

you need to edit the file

‘C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML’

Remove/comment out lines containing xls/xlsx

<Mapping FileExtension=”xlsx” RedirectUrlTemplate=”/_layouts/xlviewer.aspx?id=|0″ NoGetRedirect=”TRUE” CreateRedirectUrlTemplate=”/_layouts/xlviewer.aspx?new=1″/>

 

Reset IIS with through e.g command prompt:

iisreset /restart

Read more

http://sharepoint2010tutor.blogspot.no/2011/11/unable-to-process-request-while-opening.html

http://sharepoint.stackexchange.com/questions/64795/excel-document-opening-in-browser-unsupported-features

https://msdn.microsoft.com/en-us/library/ff595319(v=office.14).aspx

https://technet.microsoft.com/en-us/library/ee837425(v=office.14).aspx

http://stackoverflow.com/questions/22084561/difference-between-iisreset-and-iis-stop-start-command

 

 

 

Connect Excel to Oracle through ODBC

16 Aug

Steps to setup:

  1. Install Oracle client http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html
  2. Install odbc http://www.oracle.com/technetwork/topics/winsoft-085727.html
  3. Use the odbc administrator in the syswow64 directory to create a DSN pointing to oracle

 

 

4. Configuring Excel to Connect to Oracle

Open a new book or sheet in Excel. Follow the Data>Import External Data>Import Data path to select a data source. Highlight +Connect to New Data Source and click Open (or double-click it) to bring up the Data Connection Wizard.

 

 

 

 

 

 

 

 

 

 

 

 

Useful links:

http://www.databasejournal.com/features/oracle/article.php/10893_3358411_1/Connecting-with-Oracle-Accessing-Oracle-via-Access-and-Excel.htm

https://forums.oracle.com/thread/2558996

https://forums.oracle.com/message/10703232