Error when an opened Excel document links to another Excel documen

- 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
Mon Apr 21 18:13:13 PDT 2008

"Alex SC" <AlexSC@discussions.microsoft.com> wrote in message
news:191318E4-D7A2-4F16-9A1E-0FE29890E101@microsoft.com...
>- 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

--
Frank Saunders MS-MVP IE,OE/WM
Do not reply with email

AlexSC
Mon Apr 21 22:45:01 PDT 2008

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
Tue Apr 22 15:35:14 PDT 2008

"Alex SC" <AlexSC@discussions.microsoft.com> wrote in message
news:C638A71C-A479-4DFD-A898-DBBF29AD01E8@microsoft.com...
> 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.

--
Frank Saunders MS-MVP IE,OE/WM
Do not reply with email