Using Excel 2002.  I copied and pasted a pivot table to a new sheet, which I
though would create a new pivot table in its own right.  However, when I
attempt to group some fields and hide the detail, this action is copied in
the original table so I end up with two grouped tables ...

Thank God for google groups.  I used to be able to send email from
Firefox to the list.  I dont' know what is going on.
I have a sheet I'm writing some vba modules for.  I don't know how I
did this but I now have myspreadsheet.xls and another

I have several charts in a sheet for which I need to change the data
ranges. Currently each chart has a different data range, and for each
chart the new desired data range is just an straightforward extension
of the original (i.e., the new data ranges could be easily calculated

I have a problem with three table joins. I have a table that has two cells
with the title EVENTDATE. When I was using one cell the dates were fine. Now
that I am using two it would appear that the 1st EVENTDATE cells reset to the
first date entered. For example the first date is ...

Good evening all,
   I am trying to write a macro that renames the worksheets within a
workbook. My problem is that the same worksheets don't always exist in every
workbook. I am trying to create the macro to use an If statement to skip

I am trying to write a macro that renames worksheets. My problem is I don't
always have the same worksheets in each workbook. I would appreciate it if
someone could give me some direction on how to write the if statement so
that if the called out worksheet doesn't exist then it ...

Why do I lose my gridlines when I apply background color to a block of
rows? And why do I not get them back when I change the color back to the
usual white Background.
Is there a options setting I can use to prevent this action?

spreadsheet.XMLURL="....ABC.XML"; IE would be USE FULL CPU .
if the same xml file use excel to open ,that be ok!
why ? the xml file about 600K----2M

They both appear to do exactly the same thing. Am I missing something here?

I'm still having trouble with objects, but i can't figure out which
one.
Sub CopySheet()
Dim wb As Workbook

I have created a workbook that has three frozen rows at the top of the page.
Is there a way to start numbering the rows below those 3 first.
I.E.
XDate

The following expression works fine in Excel 2002 ver SP3:
=SUMIF(Carlos!B14:B74,"<6",Carlos!F14:F74)
When values in B are less than 6 the corresponding values in F are summed.
However, I do not know how to write in the correct format when I wish to sum

My apologies if anyone responded to this when I originally posted.  I
didn't download enough headers and I can't recapture the original....
I want to highlight any row that has the same data as the previous row.
 For example, if A:3=A:2 and B:3=B:2 and C:3=C:2, I want to ...

All:
I have an Excel 2002 workbook with a lot of sheets. Each of those connect to
a table in a specific access 2000 database. I had to recreate the access
database due to a hole in the security. I had to create a new workgroup file

Ok, I understand how to use macros in excel...but i need to record new macros
or build new macros...i just dont understand how to do it.  Please help!