microsoft excel training - 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 » microsoft excel training - Pivot tables

microsoft excel training - Pivot tables

resolvedResolved · Low Priority · Version Standard

Nick has attended:
Access Introduction course

Pivot tables

Hi

When I update the data source (i.e. add additional rows or columns of data) that links to a piviot table the pivot table does not update to collect the additional data from the data source. I have opened the pivot table wizard and selected the new data range and it still does not pick up the new / additional data (still only links to the old data).

Can you please tell me how to update the data link in a pivot table when additional data is added to the source table.

Cheers
NICK

RE: Pivot tables

Dear Nick

Thank you for attending our Access Intro training!!

This situation is a quiet interesting one and I agree that if you created a pivot table from your source data you should be able to easily update the it so that the pivot table is updated!!

The solutions is more simple than you might think! I think the mistake that you might be making is that you are creating the pivot table from scratch for the second time to see the additional row or the column!!
Please follow these steps:
Step 1: Go to your pivot table ( the one with the blue lines). This could be in other sheet or may be on the same sheet in other section.

Step 2: Simply right-click anywhere on the pivot data.

Step 3: Select Pivot Table Wizard. You

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

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


Server loaded in 0.08 secs.