Want to know more on Pivot tables automatic update.

Resolved · Low Priority · Version 365

Mon 17 Jul 2023, 16:31 Delegate Bamfoa said...

Bamfoa has attended:
Excel Introduction course
Excel Intermediate course

Want to know more on Pivot tables automatic update.

Tue 18 Jul 2023, 16:11 Trainer Marius said...

RE: Want to know more on Pivot tables automatic update.

Hello Bamfoa,

Thank you for your question. To set Pivot Tables to refresh automatically, you need to enable the auto-refreshing feature by right-clicking any cell in the pivot table and choosing PivotTable Options from the context menu.

From the PivotTable Options window, go to the Data tab and check the Refresh data when opening the file option.

Each time you open the file with the Pivot Table(s), it will refresh all Pivot Tables in that file automatically.

I hope this helps.

Kind regards
Marius Barnard
STL

Tue 25 Jul 2023: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Conditional Formatting in Excel 2010

If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:

1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells

To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.

View all Excel hints and tips