- Pivot table

Resolved · Low Priority · Version Standard

Pivot table

Mike has attended:
Excel Advanced course

by - delegate Mike [1 post] (2007 Sep 12 Wed, 16:48) Reply

how to reuse pivot tabkle settings using a new new spreadsheet each day . Spreadhseet is same columns just diff lwength

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: pivot table

by - trainer Amanda diamond contributer [1240 posts] (2007 Oct 3 Wed, 13:43) Reply

Hi Mike

Thank you for your question.

Would this be resolved by selecting the columns all the way to the bottom of the spreadsheet, as your data source for the pivot table? The blank rows will show up with the field heading (blank) in the pivot table, but you could hide this row or column if necessary.

I don't know if this will help but that's my suggestion.
Amanda

· MS Excel: Excel At Making The Most Of Your Christmas
· How Small Businesses Profit from Outside Excel Training
· Microsoft Excel Training Course
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· Reasons Why VBA for Excel Training Fails

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips

Rate this page: