I need help.  I read and re-read the instructions on this on the hel
on Excel 2000 and I am very confused.  Why do they make it so hard?  
just want to make a drop down list for each cell under each heading.

I'm kinda doing a personal project for myself. I want to create exce
worksheet tables for all the necessities in daily life. It will rang
from school to work to even exercises.
For example, I did already several worksheets like:

How can I get Excel to add up the components of each invoice in a lis
where the total of each invoice is one made up of any number of smalle
sums?
For example, I could have invoice numbers 1 to 3 in Column A and thei

Is there a limit to the number of data fields that can be included in
pivot table?  I have designed a pivot table that contains 90 dat
fields, but as soon as I enter data in those columns of the spreadshee
and hit "refresh data", it loses a lot of the fields.  These are no

I wrote a vba function that should return data to the excel spreadshee
after querying the Oracle database. I have installed and created
Microsoft ODBC connection for Oracle on my workstation.
If I manually open excel workbook and navigate to Data, Get Externa

Hi. I need to detect, in a VBA script, if it is executed by Excel 97. How do
I do that?
Casper

I'm kinda doing a personal project for myself. I want to create exce
worksheet tables for all the necessities in daily life. It will rang
from school to work to even exercises.
For example, I did already several worksheets like:

Months ago I had origionally changed this option, but for
some reason it has defaulted back and I can't remember how
I had changed it.
How do I change excel, so that when I open up a excel

I have a spreadsheet where every other line is highlighted (for ease o
reading). When I sort the data, the colors also change position so I n
longer have every other line highlighted.
Is there a way to prevent this from happening? I would like th

Does anyone out there know how to link a cell to a stock
quote and automatically update the quote whenever the sheet
is opened?

I'm using Office XP and am putting text I typed in tables
from Word into an Excel spreadsheet due to the columns
expanding way beyond 11x17, Word's maximum width I believe.
I set up my Excel spreadsheet columns to be wide enough to

Ok here's one that's been killing me  This version works fine
B10 to 40 are numbered 1thru 31
C10 thru 40 represent the days of the month
with C3 thru 9 representing the 7 previous days of last month.

I am a newbie to excel and have the following problem:
I want cell A1 in worksheet 2 to pick up the following:
1. look in worksheet 1 on row a3 to e3 and find the word (New User)
then if cell a3 to e3 contain New User pick up cell b18 which contain

I have a single database that is queried using the LOOKUP funtion.  Thi
function is propogated on about 30 worksheets throughout the workbook.
Unfortunately the database is not static and will gain incremental dat
overtime.  

I'm completely stuck.  I have an excel spreadsheet that uses data fro
a .CSV file.  This data (all numbers) is linked to a sheet in th
workbook.  The problem is this:
in order for the data to be updated, it is necessary to open up th