A long time back I installed Office 2003 on my machine and all went well.  I
was a bit nervous initially and so also kept Office 97 installed in case I
needed to go back and forth which it turned out that I did not.
Anyhow, yesterday I was doing some housekeeping and decided I no ...

We are using a pivot table to analyze some data we have.  Currently we are
showing the client then the product and then the sum of the Number of orders
and the percentage of margin.  The table looks like this:
Client A     Product1  Sum of ordernumber

I'm not an Excel guru but I'm good with directions--- could someone point me
in the right direction?
I have a spreadsheet with 6 columns of data that I would like to compare to
a 7th column. If a match for any cell in Column 7 is found anywhere in

We have users who user Microsoft Query to bring data into an Excel
spreadsheet.  Sometimes they need to set criteria for a field and do so by
double clicking the value field on the query form.  A dialog box appears
showing the field, operator and value.  On the right hand side of ...

Something must have changed, I guess.
Running XP.
Have two Excel file icons on my desktop.
Never had any problem opening and showing both on the desktop, and being

I appreciate if any one who is a bit more expert in excel than me can
help me make a mathematical puzzle for children. I try to explain what I
mean here:
The Idea is that we can generate numbers (say from one to ten) randomly

I've been upgrading our reporting module to output .docx and .xlsx files
instead of the Office 2003 formats (since the new ones will work for our
clients on Office 2000 with the compatibility pack), and I've come across a
major issue in the way (I believe) IE passes the files off ...

How do I add a graph showing the Spreadsheet info either at the bottom half
of the spreadsheet print or as another page.  Do I set it on another tab?

I have a two worksheet excel document.  The first worksheet has all the raw
data and formulas.  The second worksheet has some nice table layout with the
final results imprted from the first worksheet.
What I need to do is copy just the data (results) and tables from the second

If I want to make column A today's date, and column B Now, both of which
function I know how to do, is there a way to freeze these two columns when I
have entered data in, say, columns C through G so that I have an accurate
record of time and date as to when the data in the other ...

I can't fix a simple Concatenate formula that won't display it's result
(tried turning Formula Auditting mode on & off).
When I do an "Evaluate Formula" on the cells that formulas are not
displaying values in I get the following

OK, I want to protect a sheet against sorting only,
eg i want the user to be able to do everything else, just not sort the
data.
is there an easy way to do this, alternativly is there code that will

Hi, everyone -
I've been away for a little while - things going nuts at the
office..... BUT I'M BACK!!!!!
I just started experiencing a run-time error in macros created with my

I create financial models that are often larger than 15MB. Naturally,
I compress them before emailing or saving to a network drive. This has
worked great until recently when files stopped compressing very much.
The one that I'm currently working on is 18MB and only compresses to

I am reading Bill Jelen's Guerilla data analysis, in it he refers to a
Convert formula, it exists in the help menu, but i can not get this
formula to work.  It does not show up when i search in the formulas in
the 'fx' link near the formula bar anyone know the fix here?