| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding blank cells within a Pivot Table | Excel Worksheet Functions | |||
| PIVOT TABLE WITH BLANK CELLS | Excel Worksheet Functions | |||
| counting blank cells in a pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table with Blank Cells | Excel Discussion (Misc queries) | |||
| Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
Threaded Mode
