Has anyone encountered the issue below?
Upon "PivotTable" refresh, an error message occurs "The Pivot Table Field
Name is not valid.  To create a Pivot Tbale report, you must use the data
that is organized as a list with the labeled columns.  If you are changing

Is there any way to give Worksheet tabs different colours, either text
or background?

I have created a macro that can load text data into a worksheet then perform
some various calculation and make some graphs from the data.
The macro works fine on my computer.  However, when it is opend on another
computer an error "Automation Error, Unspecified Error" pops up.  The

Hi there,
I am having problem to open my excel files. Each time I open a file, it will
take 10 minutes to open a small file. However, I do noticed that there is
alot of activities outgoing in my LAN connection status.

I have two worksheets open.  In one, I can populate a cell with a formula,
set the cell colors, font, and other attributes, and then double click on
the fill cross (little black cross) and it will automatically fill the cells
below it with like formulas, fonts, colors, etc...  ...

Anyway to take text from sheet 2 in a workbook and put it into comments in a
cell on sheet 1?
Gordo

I need to align two rows of data containing date and time of equipment
readings. One is taken every second and one every 3 seconds ....
A                                  B                C                        
   D

Can anyone please help me? I have a .csv file. One of the fields is entered
as "01-04" (with the quotes). How do I get Excel to read this as a string
and not interpret it as a date (which it displays as 01-Apr)? Changing the
format doesn't help - the damage is done on reading the ...

I accidentally deleted a worksheet.  I have saved the file since then.
Excel will not let me do an undo.  Is there any way to get that sheet back?
I have not closed my file yet.  Any help will be appreciated.  Thanks.

I would like to use the same formula throughout the spreadsheet, although the
cell numbers and values will be different.  For example =b1-SUM(c1:f1).   How
do I format it so this calculation takes place for each row of cells but with
their respective cell numbers and values?

Please forgive the length of the enquire.  Hope this is relatively
easy.  I suspect it is.  Being a newbie I seek the help of the gurus
here.  I would like to be able to do the following.  I am parsing a
series of alphanumeric characters.  Lets call that PartX.  Then doing a

I want to add a template and have it show up when I go to start, New Office
Document.
I saved template as .xlt and it is in the template/1033 but it still does
not show up when I open New Office Doc.

I have a row of dates that are formatted to show the day of the week,
i.e., 'Wed, Fri, etc.
When a cell in the first row is Wed, I want the cell below it to
appear in purple. How?

I have got an Excel 2000 VBA application that sends stuff out in a batch
job. Every now and again, the app breaks down and has to be restarted again.
I sometimes lose a little bit of that or that. So how do I make Excel save
my stuff before it crashes?

tirying to fill in a column in my spreadsheet automatically.I want to start
with the number 1 and increase by 1, e.g 1,2,3 etc, in a column of cells I've
selected.believe it or not using your help system I was unable to find out
how to perform this extremely elementary operation. ...