We just install Office 2003 Prof and in Excel will opening 4 excel files
(saved in 2003 format) that are linked together and updating the data, the
respond time is very long compared with Excel 97.  The CPU usage goes to 100%
and the sheet is frozen for about 10 sec.  I did not ...

I have created a survey in Excel which will be sent via email to a lot
of respondents. The survey contains a lot of questions and for each
question, they can tick a check box on a scale from 1 to 10 (10 check
boxes for each question). How can I enter a validation that only one

... the dates are across the top row, in C1, E1, G1, etc.
Dick.

I am writing a program to examine data stored in a Lotus Notes
database.
The database in question is a fairly adevance workflow system which
produces some lovely MI on what is currently being worked on.

I have no idea what this is, but I have a spreadsheet that contains cells
with the following formula:
       { =Table(,j12) }
As far as I know there isn't an = Table function in Excel and I don't know

i have 2 different sheets with the same indentifier numbers am trying to
figuer out how to get the same numbers

I need help with figuring out how to get a formula to average a column
of numbers excluding blanks and 0's and in the same formula also having
it only calculate/average data that has a certain team name in the row.
This is the current formula I'm using but, the average is not close ...

I'm having trouble extracting data up on a cell up to a certain
character, for example up to "/"
for example this cell data:  David Staton / 102 oak st
I just need David Station and leave not / 102 oak st

I have been recording test results in a spreadsheet for some months.  Each
test produces 2 columns of data (Weight & Size).  I have, unfortunately,
been adding each new test on the left;  i.e., I add 2 rows on the left.
Now, I want to produce a sheet that summarizes this data by ...

How do I make an & appear in a footer.

Is there a way to highlight a portion of a phrase in an Excel cell and
convert the phrase to capital letters (lower case to upper case), rather
than retype the entire phrase?  Also is it possible to highlight a portion
phrase and have all the first letters of words convert from ...

Bonjour,
J'aimerais que lorsque j'entre des dates dans les cellules A33:A42, les
informations que j'entre par la suite dans les cellules B33:G42 aille
se copier dans les cellules B63:G72.

Thanks to this forum i discovered the LOOKUP function:)      Now i need
help in taking a number (1-11) and for a given number convert it to a
time period.
Example 1 = 8:00-4:00,  2 = 8:30-5:00

With a cell/s selected is there a way to convert the cell's formula into
straight numbers (in turn removing all formula and leaving the same
number)?

I need to know the formula to create a column of random 8 character ID
numbers, preferably with a set prefix of 3 numbers.  I'd be REALLY happy if
I could create it with random text and numerals, but it doesn't have to be.
(where 123 is the constant)