Pivot Table - cells imported as 'Blank'
 

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!
--
Linda

Pivot Table - cells imported as 'Blank'
 

Mathel,

I've seen this happen when there are blanks in either of the data sets.
Ensure both datasets have contiguous sets of data and attempt to recreate the
pivot tables.
--
http://HelpExcel.com




"mathel" wrote:

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!
--
Linda

Pivot Table - cells imported as 'Blank'
 

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

"mathel" wrote:

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!
--
Linda

Pivot Table - cells imported as 'Blank'
 

THANK YOU! This worked out perfectly!
--
Linda


"Shane Devenshire" wrote:

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

"mathel" wrote:

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!
--
Linda