Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Pivot tables in Excel 2003 are all fine, except - I typed a date incorrectly
in the database and now the Pivot table retains this mistake when you click the Field Name drop-down. The date was corrected, and I have refreshed all the data to the database and have tried removing the date field from the layout and adding it back again. Nothing works! Though no data is returned if this erroneous date is chosen, I would like it not to appear at all as a choice under this "Week_Ending" pivot table field. Any ideas or help will be much appreaciated! Thank you. Annie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I restore original Pivot Table data? | Excel Discussion (Misc queries) | |||
How do I view Pivot Table source data file and field names? | Excel Discussion (Misc queries) | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Pivot table - printing specific data | Excel Discussion (Misc queries) |