| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Still Dropping Data
Each time I input information into my spreadsheet and refresh my Pivot Table
data it keeps dropping my bottom portion of my spreadsheet. I have sibmitted a question for help before but the responses didn't fix my problem. Can someone please HELP! -- Sandi Gardner |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Still Dropping Data
Any chance your pivottable range needs to be readjusted.
You can rightclick on the pivottable and choose Wizard and step backward to get to the step that asks what range to use (if you want to do it manually). Or maybe you could use a name that will react to row insertion/deletion. Debra Dalgleish has some notes for dynamic range names: http://contextures.com/xlNames01.html#Dynamic Sandi wrote: Each time I input information into my spreadsheet and refresh my Pivot Table data it keeps dropping my bottom portion of my spreadsheet. I have sibmitted a question for help before but the responses didn't fix my problem. Can someone please HELP! -- Sandi Gardner -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
| Date formatting on a Pivot Chart's Data Table | Charts and Charting in Excel | |||
| Pivot table Data area show/hide behavior | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
Linear Mode
