View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cameron Cameron is offline
external usenet poster
 
Posts: 42
Default Pointing to a new data source

We have a workbook that contains a number of sheets that all inter-relate. As
far as i can tell there are only two places which this workbook calls data to
fill in the sheets. These two places consist of two buttons that link to a
SQL server. Recently we had to move the server data files over to SQL 2005
and now no longer connect to the tables in order to run the spreadsheets. How
do I change the direction in the workbook to point to the new server?