I've used the "double click" on the grand totals to display the underlying
data of a pivot table frequently. I am using Excel 11.0 (2003). Lately
whenever I do this two strange and annoying things happen: 1. The data
structure is reveresed i.e. if my database is set up as "Name", ...

When Windows boots up, the desktop window after startup is minimized (roughly
50%).  Basically, I see the same desktop view, but I have a black empty space
that frames the desktop window. I see the same view no matter which program
I'm in.  I went into settings and adjusted the ...

I am sure there is an easy answer to this question, but so far, I have
not been able to find it.  I have a cell in this format: 11/18/2007
14:33.  I need to separate the time from the date to use in a pivot
table.  Is there an easy way to do this?  Your help is very much

trying to sum a column ignoring two parameters, only successfully ignoring one.
currently using
=SUMIF(F:F,"<>-420") also want it to ignore values of -560 when returning sum.
any help appreciated.

I downloaded a calendar add in for my xl (downloaded to removable jump drive)
How do I insert it in Addins ?
Thanks in advance.

I need to use a drop-down list in a range of cells of 2 columns. In the
range of the 1st column, I'm using a simple data validation list for it's
entries, but in the 2nd column, I need to get a list with some conditions.
For example:

Suddenly, in several Excel programs, I copy and paste a formula, and the
formula is correct in the destination cell, but the value is the same as the
original cell. Yet if I delete that formula in the destination cell, and then
reenter the exact same formula, the cell has the ...

My question is similar to many others in this discussion group, but I have
searched pretty thoroughly and not found the answer to my exact question...
What I want to do is to leave a cell completely blank if the result of an
ISERROR test (shown below) is true. I need that cell to ...

I am trying to prevent people from coping and pasting into a selected range
of a worksheet. How do I do this any help?
O

I have a pretty complicated worksheet (23MB).  As such, I keep the
calculation mode set to Manual.  When I hit the F9 key to calculate, it can
take either 4 seconds or 15 minutes.  The latter finally calculates properly
but EVER SO SLOWLY.  Can someone explain why it seems to get ...

I have a list of invoices that have a colume of dates , then a colume of
amounts . I can conditional format it so that if its more than 30 days then
it changes the date to red. but is there a way of formating it so that it
adds up what is due?

I need a macro that does the following:
If a cell contains the text "N/A" I need the background color of the cell
adjacent and to the left of it, copied and pasted into the cell with "N/A"
So, B1 has "N/A".  I need the background color from A1 copied into cell B1,

I'm filling out a spreadsheet with e-mail addresses and things are
going fine; they are being treated as text which is what I want. I
don't know what I did, but when I tried to modify one addy, it turned
blue and brought up an e-mail entry with that addy in the TO: line.

this should be really easy, but I just can't workout how to do it. I have
selected a few cells and made the border thick. I now want to change the
colour of the border (but only this border) - but can't figure it out...?
Any ideas?

I have dates in the format yyyy-mm-dd. How do I get VB to convert these into
date format? I want to use the dates in a calc to determine the number of
months between 2 dates
eg 2007-06-19  and 1995-09-01