<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>On Sep 10, 2009, at 8:08 AM, Will Martin wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Sorry to bother you with requests for more details, but in working with spreadsheets since 1986, I've never worked with anybody who has asked about this feature in Excel before. It's new to me.<div><br></div><div>I pull up my virtual machine running Vista, open IE and go to the link you gave me and pull up Excel 2007 and I can't figure out how you do what you say you do in Windows Excel. Once I understand what you are doing, I can begin to research alternatives on the Mac. Until then, I'm useless to you.</div></blockquote></div><div><br></div>Oops!! I wasn't completely clear what I was doing. I am actually imbedding the query in a spreadsheet. This is a brief note I wrote to myself when I first started to play with this stuff.<div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><span class="Apple-tab-span" style="white-space:pre"> </span>On a Mac, the query must initially be stored in Office/Queries. Once there you can activate the query and imbed it in the spreadsheet via Data->Get External Data->Run Saved Query.</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><span class="Apple-tab-span" style="white-space:pre"> </span>You can remove it by finding, or knowing, the root of the query, selecting it and clicking on Data->Get External Data->Data Range Properties. You then unclick the "Save query definition"</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><span class="Apple-tab-span" style="white-space:pre"> </span>box and it will go away.</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Here is a query I prepared and imbedded in my spreadsheet. This one gets a list of the most active stocks. Stick it in Office/Queries and you will be able to imbed it in a spreadsheet.</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span></span></div></div></div></body></html>