Forum home » Delegate support and help forum » Microsoft Excel Training and help » Automation upgrade

Automation upgrade

ResolvedVersion 2003

Sun 15 Aug 2010, 15:34 Delegate Jacek said...

Jacek has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel Advanced course

Automation upgrade

hi

In Excel 2007 when I create a table, whenever I add something it makes changes to pivot tables or vlookup which are connected with Table. How can I do it in 2003?

Wed 18 Aug 2010, 10:48 Trainer Stephen said...

RE: automation upgrade

Hi Jacek

Thanks for your question

You need to refresh your pivot table for it to update. Simply click the refresh button on the pivot table toolbar and this should update the data in the pivot table.

Regards

Stephen

Wed 18 Aug 2010, 18:41 Delegate Jacek said...

RE: excel 2003

Hi,

If I add new row doesn’t work.

Regards

Jacek

Mon 6 Sep 2010, 11:32 Trainer Stephen said...

RE: excel 2003

Hi Jacek

Thanks for your question

If you run your pivot table from within code, and set the datasource property to the current region of a cell inside the data then this should dynamically pick up any additional rows that you have added

Regards

Stephen

Mon 13 Sep 2010: Automatically marked as resolved.

Excel tip:

The Easiest and Quickest Way to use Autosum in Excel 2010

Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature.

1) Go to the bottom of the column of data.

2) Shortcut click in the column then Ctrl + down arrow

3) Use Alt + = for Autosum and press the enter key to complete.

View all Excel hints and tips