excel addin options

D

douglas

I would like to ask the following questions that apply to excel 2003 and
excel 2007:
(Notes: a.Right now my comnpany uses excel 2003 and within the next couple
of months (Hopefully) we will be using excel 2007
b. My company just upgraded to sql server 2005):

1. I would like to know what kind of data mining I can setup for
excel 2003 and excel 2007. (Are there addin ribbons to excel where I can
increase the datamining that can be displayed in excel?)
2. I believe you can use Analysis Service to display data in
excel. Does the data that appears in excel need to be directly connected to
the sql server 2005 database or can the data be stored in a 'disconnected
manner'. (The data would be stored in the excel spreadsheets0
Can you point be to references on the internet and/or answer my question?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top