Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Terms & Conditions Privacy & Cookie Policy