I have found the location of the odc files and can edit the server address in them, but when you look at the connection string in Excel data/connections the sting remains the same. File Open dialog appears, and All Files (.) is shown in the Files of Type drop-down. Press F8 to open Macros window, select the OpenFile macro and run. Paste code from Snowballs original post with no changes made, close VB Editor. When I set these up I connected them to a stored procedure. Open Excel, right-click on any worksheet, click View Code. 4 In Save files in this format, select Excel 97-2003 Workbook (.xls) 5 Click OK 6 Close Microsoft Excel. My issue is that I have about 20 Excel workbooks with pivot tables running off this SQL data imported to Excel using odc connections. 1 In Microsoft Excel 2007, click File in the top left corner. I can keep the username and password the same, but will have to have a new address. The controls to configure the Auto-Recover feature are in the Save settings in Excel. More Information How to configure the Auto-Recover settings Microsoft Office Excel 2007 and Excel 2010.
This article contains an overview of the Auto-Recover feature. I'm migrating my data to a new server and therefore will have a new data source address, username and password. The files can be recovered if Excel closes unexpectedly, for example, during a power failure.
0 kommentar(er)
