excel 2003
 

have a question about Excel 2003. I am a programmer but have never used
Excel for
any programming unitl now. (Note the people who setup these spreadsheets,
are long gone).

I have a workbook that has two tabs on it. I know that there is some of a
connection made a sql server 2000 database and there must be a query to
obtain the infomation that updates the excel 2003 spreadsheet. I know this
happens since I
need to hit the 'update option' for each chart on these tabs.
Now the problem is that there is some kind of a problem, and I need to be
able to solve problems.
Ths can you tell me what I need to do in excel 2003 to determine where the
data is coming from and how the data is obtained. There must be some kind of
a query that is written.

I have figured out that if you click on the 'data' on the menu bar, then
import external data, then import data, and then click data sources this will
give you some kind of a default. If does not show where the data is obtained
from and query is used to populate the excel sheet.

Thanks fo your assistance!

excel 2003
 

Wendy,

import external data is retrieving data from other source instead of excel
files.
then excel will read source then write it into excel sheet same as source
field
with the recognized structure

--
Regards,

Halim



"Wendy Elizabeth" wrote:

have a question about Excel 2003. I am a programmer but have never used
Excel for
any programming unitl now. (Note the people who setup these spreadsheets,
are long gone).

I have a workbook that has two tabs on it. I know that there is some of a
connection made a sql server 2000 database and there must be a query to
obtain the infomation that updates the excel 2003 spreadsheet. I know this
happens since I
need to hit the 'update option' for each chart on these tabs.
Now the problem is that there is some kind of a problem, and I need to be
able to solve problems.
Ths can you tell me what I need to do in excel 2003 to determine where the
data is coming from and how the data is obtained. There must be some kind of
a query that is written.

I have figured out that if you click on the 'data' on the menu bar, then
import external data, then import data, and then click data sources this will
give you some kind of a default. If does not show where the data is obtained
from and query is used to populate the excel sheet.

Thanks fo your assistance!