Linked Server to Excel Issue

From: Raul (raul_at_nothere.com)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 13:17:01 -0800

I am using a linked server to connect SQL Server to an Excel Spread*** on
the network. If I'm physically on the SQL Server box I can open the linked
server and see the named range on the desired spread***. Also If I'm on
the SQL Server box I can query the spread*** using OPENQUERY and everything
comes across beautifully.

However, if I connect to the SQL Server box from a different location (via
Enterprise Manager) and try to run a query using the OPENQUERY and linked
server in question. I keep getting the dreaded "error 7399: blah, blah,
blah".

Any thoughts?

Thanks in advance,
Raul