I am trying to remove the "(All)" item from a PivotTable's filter dropdown.
Can anyone offer any suggestions?
Thanks in advance!
-jim

I have an excel application which sends some requests over the internet to
our servers. The user also has to provide a username password for
validation. On the server some processing is done, and the results are sent
back.

I have a simple bar graph with the Y- axis measuring vertically in units and
the X-axis a series of bars that show month 2004 then same month 2005
repeated  from november to july. The legend places the months/ year with a
colour code BUT I want to have the actual bar displaying ...

How can use the advanced filter to filter information with a certain format?

I am new to excel and I have a client that has a mailing list that wa
scanned and now in a word doc with 3 or 4 lines. ie
Name
Address

I have 7k items in my list and I would like to pull demensions from
descriptions to calculate cubic meter. Which formula helps me out?
example: (Three Noodle Chair,Rattan        38x48x31"h)
Thanks for the help.

I have a large spreadsheet, which is all the sales in my company on a
daily basis.
The data contained in cell O5  is the actual date based as dd/mm/yyyy
with cell Z5 containing the monetary value of that sale.

I want to start Excel in Print Preview. What's the quickest way?

I have a SS that I want to link to another.  The other spreadsheet would
have simply notes that would be regularly updated.  Using the hyperlink
functionality would there be a better way to do this i.e.  with say, Word?
I'm thinking long term text managment...

How would I create a formula that takes 2 different dates and determines the
number of years between them to the nearst tenth of a year.
For example, the difference between 1/1/03 and 7/1/05 is 2.6 years.
If I use the DATEDIF function, I only get a rounded number.

Looking for a simple football pool template for a friendly family Bowl Game
TV party.

Hi all - I manage a major account with many locations.  I created a SS to
list each location and the sales person handling it.  Some locations have
lots of sales activities others may have nothing.  I linked the SS to
another SS that maintains a list of the contacts for each ...

I want to do hyperlink to another file in the same folder. I want t
transfer this folder to another computer, so I need the hyperlink t
include only the address to the folder and not to include all the path
could I do it?

Can you help me with a little problem.
I am running a macro on a csv file.
There are 4 dates in the format dd/mm/yy and I format them to dd mmm yyyy.
So the cell A1 originally has the value 25/12/05, I format it so the cell A1

Can anyone assist me please
I'd like a column of cells to report the instance of a certain word in a
line of text in the column cells to the left
i.e.  Find all instances of "apple" in the cells below