| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why would a pivot table lose its character?
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!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why would a pivot table lose its character?
Is the sheet which contains your pivot table protected perchance?
If so Unprotect it. HTH On Mon, 11 Sep 2006 08:00:02 -0700, JohnK wrote: 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!!! __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Top 5 plus Other in Pivot table | Excel Worksheet Functions | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
Linear Mode
