Why would a pivot table lose its character?

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

Guest

I have been using a Pivot table to accumulate data. I opened the file and
input my data. I went to my Pivot summary and it wouldn't allow me to
"refresh my data". In other words, the PT command to refresh my data was
"greyed out".

Help!!!
 
Is the sheet which contains your pivot table protected perchance?

If so Unprotect it.

HTH


I have been using a Pivot table to accumulate data. I opened the file and
input my data. I went to my Pivot summary and it wouldn't allow me to
"refresh my data". In other words, the PT command to refresh my data was
"greyed out".

Help!!!
Click to expand...

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Is the sheet which contains your pivot table protected perchance?

If so Unprotect it.

HTH


I have been using a Pivot table to accumulate data. I opened the file and
input my data. I went to my Pivot summary and it wouldn't allow me to
"refresh my data". In other words, the PT command to refresh my data was
"greyed out".

Help!!!
Click to expand...

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
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

Workbook pivot table design function 6
Adding data to a 2007 pivot table 2
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1
Pivot Table Help! 1
How to clear data in pivot table? 4
Pivot Table Filters 2
Refreshing Pivot Tables 2
Pivot Table Refresh Not Updating Drop Down List 1

Back
Top