LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pointing Finger Mouse Gaffnr Excel Worksheet Functions 1 June 8th 09 12:47 PM
display data in stock chart by pointing cursor Shawn Charts and Charting in Excel 1 March 3rd 08 01:09 AM
pointing to the c:\ drive Cockneygeordie Excel Discussion (Misc queries) 0 July 5th 06 03:34 PM
Pivot Table data source "data source contains no visible tables" Jane Excel Worksheet Functions 0 September 29th 05 08:28 PM
How can i set the source-data-range of pivottable2 to the source . Piet Excel Discussion (Misc queries) 0 March 5th 05 09:31 PM


All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"