I am trying to graph a set of data in 'XY (Scatter)' and am running
into a problem I've never seen before.
There are only seven values for 'X' - numbers 0 through 6.
'Y' is a set of percentages ranging from '0.00%' to '13.00%'

I am making a table and the top row has all the headings for each column. I
want this row of headings to appear on each page, since the table extends to
3 pages and users will be adding rows frequently. Is this possible, and if
so, how?

I would like to schedule a macro to run at 22 minutes and 52 minutes past
the hour, so that the latest information available to the spreadsheet is
updated asap (usually available by 21 mins and 51 mins past the hour) to
remove the problem of the user forgetting to do so manually.

In range of data I need to find jthe largest numerical movement in one
direction without (x) retrace.   (x in this case being a specified whole
number)  
Please help with a formula or direct me to where I could find this

Just when I think I'm getting used to Excel, I come up against something
that reminds me how much I don't know.  I hope one of you good guys can help
me out.
Essentially I have two worksheet listing competitors in an annual race.  One

I am trying to write some visual basic code behind a macro and I want it to
do the following.
1) Select the whole of coloum C
2) Activate the find box as in (CTRL + F)

Can anyone tell me if you can alphabetize sheet tabs within a workbook?

If i want to filter a single column to only show A G, J, and P ( i choose
these letters as they cant be lumped together as a range) how would i do
that in a maro or VB
Any tips appreciated

I have several spreadsheets in the same workbook, I would like the
information one sheet to update another spreadsheet as well as the current
spreadsheet searching lines for in itself for specific items and copying them.
Example:

I would like to set up Excel worksheets that correlate to tests I give my
students. Each question would have a statement that would be given for a
correct answer and a statement given for an incorrect answer. Once he
worksheet was built all I would have to do is input the ...

I'm trying to figure if the following can be streamlined a bit:
SUMPRODUCT((WORKSHEET1!$A$2:$A$1000="JANUARY")*(WORKSHEET1!$H$2:$H$1000="JOB1")*WORKSHEET1!$E$2:$E$1000)
This formula is found on Worksheet2...I also have headings for JANUARY,
MONTHS etc.... & JOB1, JOB2, etc..... ...

why does it happen that, when I enter in a cell a number like:
38 685 626 227 668 133 590 601 792,
in the cell it immediately appears as:
38 685 626 227 668 100 000 000 000?

Can Excel 03 and 07 be installed on the same computer?
I am using Project Server 03 and Office 07.  A Project Server 03 desktop
function needs Excel 03 installed.

hello! I use excel 2007
iI open a connection agianst SQL server 2005 and choose a table. In my
workbook i can now see this data from this table. if i change a value in some
cell i wish to writeback to table in SQL server. Is this possible?