98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » vba for excel training - Pivot Tables
vba for excel training - Pivot Tables
Resolved · Low Priority · Version Standard
Carl has attended:
Excel Advanced course
Pivot Tables
Can I select a greater area than the current information on th espreadsheet to ensure I capture all new data
RE: Pivot Tables
Hi Carl
Thank you for your question.
I'm not sure whether there would be an implications associated with selecting a larger data area than necessary for the pivot table.
What you can do is set up a dynamic data range, by creating a named range which will automatically expand itself. For further details on how to do this, please see www.contextures.com/xlPivot01.html
I hope this helps.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Selecting constant values onlyIf periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter. |