Error when an opened Excel document links to another Excel documen

[Alex SC]

- The user clicks on a link on our intranet
- An Excel document is opened in IE
- In this Excel document you can click on a button/column that updates the
values in columns with values from another Excel-document (placed on a
fileshare /file server)
-This command does not work. It stops on "Workbooks.open xxx " (the
specified second excel file).

All of this works just fine if you perform it in Excel instead (save the
file and open it from Excel instead of inside Internet Explorer), then the
data from the second Excel-file is updated into the first Excel-file.

Have you any idea on how to solve this so the users can use the Excel doc.
in IE?

Best Regards Alex

 

[Frank Saunders MS-MVP IE,OE/WM]

- The user clicks on a link on our intranet
- An Excel document is opened in IE
- In this Excel document you can click on a button/column that updates the
values in columns with values from another Excel-document (placed on a
fileshare /file server)
-This command does not work. It stops on "Workbooks.open xxx " (the
specified second excel file).

All of this works just fine if you perform it in Excel instead (save the
file and open it from Excel instead of inside Internet Explorer), then the
data from the second Excel-file is updated into the first Excel-file.

Have you any idea on how to solve this so the users can use the Excel doc.
in IE?

Best Regards Alex

How to Configure Internet Explorer to Open Office Documents in the
Appropriate Office Program Instead of in Internet Explorer
http://support.microsoft.com/kb/162059

 

[Alex SC]

Is there a solution to solve this problem with this Excel-document without
changing the settings? Because we are not allowed to change the settings so
that Excel is always started when opening documents from the web.

Is there e.g. an html code we could write to open Excel only for this
particular document but otherwise always open IE?

Best Regards Alex

 

[Frank Saunders MS-MVP IE,OE/WM]

Is there a solution to solve this problem with this Excel-document without
changing the settings? Because we are not allowed to change the settings
so
that Excel is always started when opening documents from the web.

Is there e.g. an html code we could write to open Excel only for this
particular document but otherwise always open IE?

Best Regards Alex

I don't know any other solution besides forcing all employees to watch while
you cut off the head of the next user that does not save the document before
making changes.