Opening Excel workbook error

Question

Hi,

It was my stupidity to play around with the Excel Services. I just want to know how to i disable this services. I want to let user to open up any shared documents in the normal Microsoft Excel application rather than the web browser like how they used to do it.

Kindly help.

Thanks alot.

Answer 1

Below steps helps... Go to users PC and do the following steps.... 

1. Launch Windows Explorer.
2. Select “Folder Options...“ from the Tools menu.
3. Select the “File Types“ tab.
4. Scroll down the list of “Registered file types“ until you find “XLS - Microsoft Excel Document“ and select it.
5. Click on the “Advanced...“ button at the bottom of the dialog.
6. Uncheck the “Browse in same window“ checkbox.

For details visit : http://blogs.msdn.com/gusperez/archive/2004/04/28/122768.aspx

http://social.msdn.microsoft.com/Forums/en-US/sharepointgeneral/thread/cf74eaed-52ee-462b-bea9-71276f5266f8

---

K.Mohamed Faizal, Solution Architect, Singapore
http://faizal-comeacross.blogspot.com/

Answer 2

Excel Services questions go to the Excel Services forum.

However this isn't an Excel Services question as can be seen by the answer.

(So I'm leaving it here)

(Moderator)

---

WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx

Answer 3

Below steps helps... Go to users PC and do the following steps.... 

1. Launch Windows Explorer.
2. Select “Folder Options...“ from the Tools menu.
3. Select the “File Types“ tab.
4. Scroll down the list of “Registered file types“ until you find “XLS - Microsoft Excel Document“ and select it.
5. Click on the “Advanced...“ button at the bottom of the dialog.
6. Uncheck the “Browse in same window“ checkbox.

For details visit : http://blogs.msdn.com/gusperez/archive/2004/04/28/122768.aspx

http://social.msdn.microsoft.com/Forums/en-US/sharepointgeneral/thread/cf74eaed-52ee-462b-bea9-71276f5266f8

---

K.Mohamed Faizal, Solution Architect, Singapore
http://faizal-comeacross.blogspot.com/but i need to configure back the settings to the way it used to be in the Central Administration. the method given would require me to go to each PCs and do that.

 

 

thanks

Answer 4

Excel Services questions go to the Excel Services forum.

However this isn't an Excel Services question as can be seen by the answer.

(So I'm leaving it here)

(Moderator)

---

WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx

sorry i didnt noticed the Excel services thread. perhaps you can help me moved it to there for faster reply.

thahks

Answer 5

At the document library in which your Excel files are stored, you can control whether to open documents with normal Excel application or with a web browser by default (settings->document library settings->advanced settings-> Browser-enabled Documents).

 

No matter what the default setting is, end user can choose to open Excel files with client application or web browser (choose Edit in Microsoft Office Excel or View in web browser on the Edit dropdown list for the document library item).

 

If you really want to stop Excel Calculation Service, you can do so on Central Administration->operations->Services on Server, click stop for Excel Calculation Services.

 

Alternatively, if you remove the document library from the trusted file locations (Central Administration->Shared Service Administration->Trusted file locations), user will also not be able to open Excel file in this document library in web browser even if the Excel Calculation Services are still running.

Answer 6

Gu Yuming,

Xie Xie Nie.

This is what I wanted. Thanks alot!

Answer 7

I can understand the difficulty of going though end use PC’s and change setting. Since the issue related to End User PC’s you need to the setting at End User PC’s Level.

OR

Explore how to use Windows server Group Policy to push changes to all users

---

K.Mohamed Faizal, Solution Architect, Singapore
http://faizal-comeacross.blogspot.com/