Pivot Table - cells imported as 'Blank'

M

mathel

I am using Excel 2003. I have a Master List of items updated by various
employees. From this Master List, I need to create a Pivot Table in a
separate workbook. There are 2 columns of data in the Master List, one is a
Date formatted dd-mmm-yy, and the other is a Dollar value which I have
formatted as 'Accounting $'.

When I create the Pivot Table, all the data comes through OK except the Date
column and the Dollar column; they show as (blank) even though there is data
in the Master List.

Can anyone tell me what I am doing wrong?
Thanks!
 
S

Shane Devenshire

Hi,

Create the pivot table as follows:
1. Select the entire range manually!
2. Choose Data, PivotTable and PivotChart Report,
3. Click Next, check to see that the data range includes all your data
4. Click Next and choose Layout
5. Drag the Date field button to the Row area, and the Amount field button
the the Data area
6. Click OK, Choose Existing worksheet and navigate to the other workbook,
select a sheet and a cell and click Finish

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
M

mathel

THANK YOU! This worked out perfectly!
--
Linda


Shane Devenshire said:
Hi,

Create the pivot table as follows:
1. Select the entire range manually!
2. Choose Data, PivotTable and PivotChart Report,
3. Click Next, check to see that the data range includes all your data
4. Click Next and choose Layout
5. Drag the Date field button to the Row area, and the Amount field button
the the Data area
6. Click OK, Choose Existing worksheet and navigate to the other workbook,
select a sheet and a cell and click Finish

If this helps, please click the Yes button

Cheers,
Shane Devenshire
Click to expand...
 
Top