We are currently in the process of moving our Sharepoint 2007 server from one farm to another and the URL is going to change. We have a lot of users who edit and update their data using Excel 2003 ( Using the Export to Spreadsheet option ).
Some of these spreadsheets have multiple tabs and VBA code for processing the data and generating reports. There is no menu option that lets us edit the query to make the change to the URL. Is there any easy way to replace the URLs of
these queries to point to the new URL?
View Complete Post