I have an excel sheet that I have MS Query attatched to. Recently, our servers were renamed to something different. I have changed my ODBC connections on my computer and updated my other excel sheets to point to the correct server via Script Editor, however, on one particular spreadsheet, the script editor is disabled and I can't update the path.\\trap-true, etc.
How can I tell this worksheet to point to the new server? There has to be something in the background where I can tell it to go.
BTW.....I've tried opening the Query and because the new server is down, it will not connect to allow me to cut and paste the SQL code to another worksheet.
Please help
Bookmarks