Re: Refreshable spreadsheet question

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Tue, 25 Mar 2008 11:35:12 +0200
Message-ID: <47E8C750.6080806@inter.net.il>


Hello Sweetser

Right click on the cell in the spreadsheet and you can see the name in the edit query (or something like this). You can also see the name in the query properties.

Adar Yechiel
Rechovot, Israel

Sweetser, Joe wrote:
> Not completely Oracle related but thought I'd give oracle-l a shot. I
> can't find anything on Metalink or Google yet.
>
> I have been given a refreshable spreadsheet - and, oh, what a joy, :-)
> that connects to an Oracle financials database here in the shop.
>
> Windows Env: Excel 2002 running on XP Pro SP2
> Oracle Env (though I don't think it's particularly relevant to this
> question): 9.2.0.8 running on RHEL.
>
> I am trying to determine the *existing* data source the spreadsheet is
> trying to use and having no luck at all. If I try to refresh the data I
> get an MS ODBC error saying that the data source name is not found and
> there is no default driver specified. Fair enough. I believe that
> since I haven't set up any ODBC connections on my laptop. And when I
> click OK I get a dialog box that allows me to choose a data source. But
> is there a way to determine what data source the initial/existing
> query/connection is using? I'm thinking the long since gone developer
> of the spreadsheet used a connection s/he had set up on their laptop.
>
> Thanks,
> -joe
>
> I hope...that mankind will at length, as they call themselves reasonable
> creatures, have reason and sense enough to settle their differences
> without cutting throats; for in my opinion there never was a good war,
> or a bad peace. -Benjamin Franklin
>
> Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 25 2008 - 04:35:12 CDT

Original text of this message