I have several sheets as keys -an employee key, percentage key and a pay
grade key.  I hope this makes sense.  On the employee key I would like to
pull in paygrade comparisons from the grade key spreadsheet.  For example,
the employee earns 5.00/hr, on the FY03 grade he is in the ...

Can you do a conditional format in a pivot table? For instance, for each
value in the table over 1000 shade that cell red and for each over 5000,
blue....

While using Word, we may pase a print screen and use call outs and some other
auto shapes with text to explain a context.  The requirement is a lock to
have the objects (picture, shapes etc) fixed on the canvas and to prevent
them from being disturbed.  This is required without ...

For example, I am organizing a new document that needs to be alphabeticalized
for easy referrence. Each topic though has sub bullets. I've tried to sort it
by highlighting the spreadsheet but it rearranges the whole text.
Is Excel the better product or would Word work better?

I apologize if this is the second question on the same topic... new to this
forum... I use excel for cash flow and use links frequently... recently,
though, it appears that SOME (not all) links require all the linked files to
be open in order to see the value vs #REF!... I've ...

I have a .csv file that I've pasted into an EXCEL 2002 worksheet.  In one
column, the string "All GL Accounts" appears in multiple cells.  I need to
locate those cells and then BOLD the entire row where those cells are
located.  Can someone tell me a reasonably simple way to do ...

I have a large table of inventory transaction data that generally looks like
this               
Data               
Date    Item    Source    Destination     Qty

When I use {=FREQUENCY(INDIRECT($A$1),Bin_Range)} I get a column of #REF!.
A1 can contain one of two valid range names.  
The frequency function works when either of the two are entered directly or
even when an IF function replaces the INDIRECT function e.g.

Hi, now J Latham provided this to me, I am no WHIZZ with formulas and
have finally found out where to put it. I wonder if some kind person
could help me out. Now this works without any run time errors but
does'nt do what it is supposed to do the whole sheet comes up empty

I want to archive a spreadsheet (and freeze those cells that want to
update itself) so that when I access it one year later, it no longer
updates the cells that have functions like "  =today() ".  I would
want to freeze those particular cells so that when I froze those

OS=MSWin2000
App=MS Excel 2003
Within a single workbook, this is what I want to accomplish:
1) Examine the value in a specific cell of my main worksheet (e.g., AB2

I am trying to create a Pivot Table to show the WOS (weeks of stock)
by week for YOY (2005, 2006 and 2007) for certain product families.
WOS = OH/AWS where OH = On Hands (available data) and AWS = Average
weekly sales (also available data). I did the WOS calculations myself

I believe these problems have the same solution.
1st problem:
I would like to be able to remove the zero that is placed 3 digits from the
RIGHT.  The values are:

I have the following table in a1:e6
Active       24,999    74,999    99,999      149,999
7    4.25%    4.35%    4.45%    4.75%
16    4.25%    4.45%    4.55%    5.05%

I have always been able to view my highlighted cells while working in my
document but recently, the only way to view highlighted cells is by
previewing document or printing it out.  Does anyone know how to correct this.
Thank you