I have a pivot chart set up and have it as a "column - line 2-axis"
chart type.  Everytime I choose something different to display in the
chart, it reverts back to a plain ol' column chart type.
I wrote a quick macro to detect the pivot chart change and set it to

Am I the only that thinks Office 2007's silver scheme in ribbon apps looks
"dirty?" I don't know it just looks.... um, not very good. It's not the same
color set as Office 2003's silver colors (at least it doesn't seem so)...
and it's definately not the same color set as XP's ...

I have created an MS Word 2003 document that contains "manual linefeed"
and paragraph marks. Each new record is separated by 2 paragraph marks.
How should I save this document such that when it is imported into MS
Excel, it will keep each record separated?  Currently, when I import

I cannot type anything on the spread sheet. How do I fix it? I can type on
other things but not on this. Do I have to renew it? And if I do, how do I do
it?

I have a worksheet built by someone else with many macros built in and
they all are operational - no error messages.  I want to edit one macro
in the worksheet.  I follow the steps:  Tools, Macro, Macros (here I
get the list of macros in the spreadsheet).  I select the name of the

I am looking at timestamps on a server log and trying to average the
difference between the times in a pivot chart. The time is milliseconds and I
just want the flat number.  Since the timestamp is based on the calculation
from a certain point in time, it wants to convert the ...

I'm using regular Excel formula in the cells (not scripting, mainly
because I don't know how). I have a problem with trying to combine
offset() and small()
my actual code is:

Without using Cut/Paste or Drag, is there another way to move the contents
of a selected cell to another cell on a worksheet?
Thanks
CJ

In a large spreasheet, I want to be able to count the number of rows where
column O is a nonblank (has some type of data entered - may be alpha or may
be a date) AND column P = "Y".
Can someone please point me in the right direction in terms of which formula

When using the Excel AutoFilter, I would like to perform operations on the
filtered results displayed.
Some operations like AutoSum work (adding up only the filtered results
displayed), yet operations like COUNTA do not work.

I am setting up an inventory sheet and everytime I try to enter 4-0 under
size it comes up APR 00 and when I do 5-0, I get May00. How do I change the
column so it allows 4-0 or 0-0?

Hello fellow Excel users.  I've researched this group and view PERSONS
site on time...but I'm not able to come up with the correct formula.
I'm trying to create a project timesheet our tech use in the field.
However I can't get the standard time and the prime time formulas to

I have two lists. The list B contains some same cells with List A. How can I
find all the duplicate cells on list A and than delete both cells?

I found that option in excel 2003, but I can't in 2000. Is this
possible? Thx for answers.
goodghost

I need to insert a current stock price into a single cell of an Excel
worksheet. When I go to Data > Get External Data >Run Saved Query >MSN
Money Stock quotes, the whole web page gets inserted. There's another
way somone suggested using smart tags (I think it only works on