Pivot tables

Resolved · Medium Priority · Version 2010

Wed 15 May 2013, 17:02 Delegate Katy said...

Katy has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course

Pivot tables

Good afternoon

I have created a pivot table that seems to be working fine.
However, when I want to add another row to the bottom of the source table, the pivot table is not picking up the new information.

Is there any way round this?

Thanks for all your help, really appreciated.

Katy

Wed 15 May 2013, 18:38 Trainer Rodney said...

RE: Pivot tables

Hello Katy,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding Pivot Tables and adding more data to the source table which by default doesn't get added to the PivotTable.

There are a few suggestions I can make to help you with this issue.

1) Use the Change Data Source button located on the Options ribbon to change the range to include the rows or columns of new data.

2) Before adding new data, insert new rows within the data range and then add the data. On the Options ribbon click the Refresh button to update the PivotTable.

3) Format the source data range as a Table and then use the bottom right-hand corner of the range to expand both rows or columns. Provide as many rows/columns as required and fill in the data. Refresh the data in the PivotTable as in 2 above.

4) You can also name the source data range and create a dynamic named range. This method is beyond the scope of this forum and can be learned when attending our PivotTable training course which covers one day.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Use RANDBETWEEN to generate random numbers

There may be occassions where you need to generate random numbers in your spreadsheet. Use the RANDBETWEEN function to generate random numbers between two values that you specify.

The function looks like this:

=randbetween(LOW,HIGH)

where LOW is the lowest number you want generated; and HIGH is the highest number you want generated.

This formula will work with both positive and negative LOWs and HIGHs. Also it will only generate integer numbers unless forced to do otherwise by the following:

=randbetween(LOW*10^PRECISION,
HIGH*10^PRECISION)/(10^PRECISION).

where PRECISION represents the levels of decimal precision needed (i.e. if you need numbers with one decimal place, PRECISION would be 1; 2 for two decimal places and so on).

One final note, if the RANDBETWEEN formula does not work in your spreadsheet or returns a "#NAME" error, you need to install the Analysis Toolpak Add-In. You will need to press F2 then Enter following the installation.