I need to create a calculated field in a pivot table that would be the
ratio of two running totals already in my pivot table.  I would like
to avoid doing the calculation in cells outside the pivot table.
Here is how my data needs to look and I am unable to get the ratio

When try to type '&' sign in Excel-2003 header text it doesnt show in the
'print view'.
Does it need to be inserted as a symbol, and if so, how can a symbol be
inserted into header text ?

I have 193 rows on my spreadsheet, with the top 2 rows frozen to view as I
scroll down the list of rows. I would like to bring the rows to meet the
frozen information but it is only letting me see every 3rd row instead of
each row one at a time.

In Excel 2003, the rows only go halfway down the page when I do a Page
Preview and the right sidebar won't move any further down.  I would like to
add more rows.  I tried moving the page break insert, but it didn't change
the # of rows.  Help!

I have a one-sided flyer that will be tri-folded for mailing. Before folding,
how do I print the addresses from an Excel table on the blank side of the
flyer?
And how do I include my return address?

Can a HIDE Row(s) or  Column(s) statement be imbedded in an  IF statement?
For instance, what might be the real way to write what I hope is obvious in
the following?
=IF(A1=B1,"Yes",Hide Row x)    where if A1=B1, then Yes is shown, if not

I use the "text to columns" (data menu) feature to copy data I get from an
internet site onto my EXCEL spreadsheet.
To be more specific, I copy data for 1)the location, 2) the latitude, and 3)
the longitude into colukmn A ONLY:

All, below is the code that I use to delete contents of the open sheet. How
do I make it ask or show a message box with 'Yes' or 'No' asking to delet or
not? Thanks in advance.
   Cells.Select

Sorry Guys,
I have looking around on a bunch of websites on calculating days between
dates (sort of) and it's almost working but I need it to really work.
I need a cell to return the number of days a patient was on a ventilator.

I have a workbook with 4 pages, I want to deny access (to view) to just one
of those sheets but allow access to the other 3.
Is this possible
thanks

My doctor suggested I get a home blood pressure monitor and take a
reading every day or so. I put the data in a Word table and am amazed
at the variability.
I am wondering if someone can tell me what type of analyses I should

I'm using excel 2007 with vast amounts of data - file listings of
300,000 files, database dumps that i need to analyze, which have 20
columns and 100,000 rows, etc - and I find that i am crashing excel
pretty often.

Trying to set up a file where I can list items in column a with their out
dates in column b and would like to set it up so I get an alert one month
before the outdate.  I was given this formula but get an message that says
there is an error in it.  any idea what is wrong.  

Hello,
I have a spreadsheet with data from a datebase that list dates with no
slashes. How can I add slashes?
Current format -7132007

I need to make a calculated field based on two running totals:
Week   Metric1    Metric2    Ratio
1