I have following data
NAME    XVALUE  YVALUE
NAME1  12.5          81.5
NAME2  22.5          51.5

I have a workbook with several sheets in it.
When I fill a cell with a background colour or pattern on the first sheet
the colour and/or pattern do not print or appear on print pre-view.  On
other sheets in the workbook fills appear correctly.  Is there a switch

For some reason, the immediate window has gone from the VBE, instead there
is a black space where it should be.
View -> Immediate window doesn't do anything.
Any idea?

I have a sheets, in which Col A has supplier names, Col B has part
supplied by the supplier and Col C has qty supplied.
Supplier         Part          qty
AAAAA          XXXX        2222

I'm using Excel 2003.  I know how to use Control and ; to insert a date
(and also how to use the date format command) in a cell.  However, I
have to manually type in the day next to it.  The date format does not
give me the option of 'Thur 11/01/2007' simply '11/01/2007'.  Is there

I'm using Windows XP and Excel 2003.
For example, the option "Share workbook" or "Options" under Tools or
"Freeze Panes" under Window are grayed out.  I can't select them.  How
can I correct it?

I need to look thru a range "  Worksheets(1).Range("R4:AI7000")   " row
by row and hide the row if "ICG" is not in any of the 18 cells in that
row. Similar to what AutoFilter does only in VBA.
"ICG" can show up once or twice per row and in any position along the

I would like to dynamically change the units on my graph within my
powerpoint presentation using VBA.  The Powerpoint group has site has
been down for a couple of days so I have not been able to send my
question in.  I would think the code might be similar to that in excel

I have a sheet, in which, col A contains name of suppliers (sorted
alphabatically) and col B contains qtys which was delivered by the
supplier.
Now i have get the sum of the qty based on the supplier.

In one sheet of a multi-sheet workbook, I've got a column of customer
numbers. In a separate sheet, I've got a column of customer numbers which
represents a subset of the whole customer list.
I need to be able to add an alpha code (single letter) in a separate column

Is there a data tracking wizard in excel 2003 similar to the feature in
previous versions of excel? I would like to use a form template that creates
a database record in a linked spreadshet. Thanks.

I am writing a code in excel VBA for word.  I am linking tables from
various excel files to one word document.  I need to specifiy which
excel file table is placed into the word document.  The code opens up
several excel files of the users choosing, renames that path to

How can I get Excel to display text in caps without having to use
formuli? There is no facility like work to set Font to Caps or small
caps or do a custom Text format or is there?

Is there any way to cross-reference a section of an Excel worksheet so
that you can jump to that section merely by clicking on the pertinent
link?  I know MSWORD has this type of cross-referencing capability, and
I use it extensively.

Using 2003
Column A  holds WBS codes.  Column B holds WBS description.  Column C
holds manhours for the selected WBS.  I want to run a pivot that shows
a sum of the manhours for each WBS.  When I run the pivot wizard, I get