Reply to thread

Message: [QUOTE="Kelvin, post: 12637404"] I've inharited a spreadsheet that connects to an external source, our SQL 2005 server. I've altered the query to reflect our server name and saved it in Excel as a query with a new name. If I press F5 I can select the range, then I click on the Edit Query icon . First it says "This query cannot be edited by the Query Wizard", I press OK. Then it says "Invalid object name "TheirSERVERNAME.odb.SVSLSITM, Statement(s) could not be prepared", which makes sense since their server is different then ours. If I press OK there it takes me to basically a blank screen/grid. If I click the SQL button there I can see their old query. If I click the Open button my query is in the list (I deleted their from this Open Query dialog box) and can select mine. My query opens fine and has my data there. How do I get this spreadsheet to look at my data rather then the old one I deleted? The Help menu was trying to get me to go to Edit/Links on the Excel menu, but Links is grayed out... I'm stuck, can someone help me out here? I'm using Excel 2003 if it matters Thanks Kelvin [/QUOTE]