creating pivot tables excel 2004 for mac

My data source is a simple data table in a worksheet, like this:

id |name |age
-----------------
1 |John |5
2 |Peter |10
3 |Josh |20

but when I create the PT it only show headers

id | name | age

doesn't show data in the PT

I check all pivot table options, like: data source (range), I try using the
layout option and also I compare the pivot table options in pc with mac and
everything look good.

When I create a PT on pc after add a field all data of the data source
appear in the PT but isn't the same on mac, after add a field only appear the
header.

Maybe this can give a clue of my problem.



"JE McGimpsey" wrote:

> In article <80245DE7-6494-4796-A9BA-1AB883DBD745.RemoveThis@microsoft.com>,
> Robin <Robin.RemoveThis@discussions.microsoft.com> wrote:
>
> > Hi,
> >
> > Why in excel 2004 for mac when i create a pivot table doesn't show data, i
> > checked all options and data source but that look good and also when i open a
> > workbook that have a pivot table generated in a pc it look nice but if a hide
> > only one field or change any option all data disappear? please help!!!
>
> Hard to tell what's going on from your problem statement.
>
> What are you using as your data source?
> What do you mean by "checked all options"?
>
> Giving some detail may help to narrow down the problem.
>
 >> Stay informed about: creating pivot tables excel 2004 for mac 

In article <23426790-E10C-42E5-8C2A-E5B6A7B07E4A DeleteThis @microsoft.com>,
Robin <Robin DeleteThis @discussions.microsoft.com> wrote:

> My data source is a simple data table in a worksheet, like this:
>
> id |name |age
> -----------------
> 1 |John |5
> 2 |Peter |10
> 3 |Josh |20
>
> but when I create the PT it only show headers
>
> id | name | age
>
> doesn't show data in the PT
>
> I check all pivot table options, like: data source (range), I try using the
> layout option and also I compare the pivot table options in pc with mac and
> everything look good.
>
> When I create a PT on pc after add a field all data of the data source
> appear in the PT but isn't the same on mac, after add a field only appear the
> header.
>
> Maybe this can give a clue of my problem.

I'm still not sure what you're doing to create the pivot table. You
don't say what fields you're using for rows, columns or data, so it's
hard to know what to suggest.

I created a Pivot table using your data using the following steps:

1) I reproduced your data above in A1:C4.
2) I chose Data/Pivot Table Report...
3) In step 1 of the PT dialog, I chose Microsoft Excel
list or database as the data source, and clicked Next.
4) In step 2 of the PT dialog, I confirmed the data range
is $A$1:$C$4 and clicked Next.
5) In step 3 of the PT dialog, I selected the "Existing Worksheet"
radio button, entered $F$1 in the input box, and clicked Finish.
6) From the PT toolbar I dragged the id field to the PT section
labeled "Drop Row Fields Here".
7) From the PT toolbar I dragged the name field to the PT section
labeled "Drop Column Fields Here".
8) From the PT toolbar I dragged the age field to the PT section
labeled "Drop Data Items Here".

The resulting PT is

F G H I J
Sum of age name
id John Josh Peter Grand Total
1 5 5
2 10 10
3 20 20
Grand Total 5 20 10 35


What happens when you try these steps?
 >> Stay informed about: creating pivot tables excel 2004 for mac