pivot tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

Pivot Tables

resolvedResolved · 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


 

Excel tip:

Line breaks in a cell

You 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.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips


Server loaded in 0.08 secs.