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 » Pivot Tables
Pivot Tables
Resolved · Low Priority · Version 2003
Amanda has attended:
Excel Advanced course
Pivot Tables
Can a defined dynamic range (e.g. one with a Count function in order to automatically extend a range) be used by a pivot table, provided you refresh it?
RE: Pivot Tables
Hello Amanda
Thank you for your question and welcome to the forum.
Please see the following link on using a dynamic data source for a pivot table - I hope you find this useful, if not please reply and let me know.
http://www.contextures.com/xlPivot01.html
Kind regards
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:Line breaks in a cellYou can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it. |