Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

- Pivot table

Resolved · Low Priority · Version Standard

Reply Wed 12 Sep 2007, 16:48Delegate Mike said...

Mike has attended:
Excel Advanced course

Pivot table

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

For upcoming training course dates see: Pricing & availability

Reply Wed 3 Oct 2007, 13:43Trainer Amanda said...

RE: pivot table

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

Excel articles

· Data Validation In Excel
· Tracking In Excel 2003
· Preparing to Pivot: Why all Excel users should know about Pivot Tables
· Tips to Facilitate Printing of Excel worksheets
· Share And Share Alike - Use Excel To Collaborate As A Winning Team!

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips