drop down arrow missing from Pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
When I go back to a pivot table I have set up, the drop down arrow within
all the fields disappears. Does anyone know how I can retrieve these? Is
there some kind of function to turn this on/off?

thanks
 
Are you sure you haven't copied and pasted the table as values, as this would
give the appearance you have just described. is the pivot table still
functional in that you can drag fields around and have it update in front of
you?

Regards
Ken...................
 
No definitely have not copied the table - i can still move the fields around
as normal, just the arrow has disappeared.
 
What version of Excel are you using? In Excel 97, the field buttons
don't have dropdown arrows.
 
Are objects visible? (Tools>Options, View tab, Objects: Show All)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Drop Downs 3
Pivot table drop downs not refreshing 1
alt down arrow shortcut not working 0
Excel 2003 - Can't format Pivot Table 1
Usability - drop down box - Arrow INSIDE box? 1
Access #Error & Excel Pivot 0
Pivot Table issue in Excel 2007 1
pivot table - drop down filter box has 10% of items out of order 2

Back
Top