Automation upgrade

Resolved · Medium Priority · Version 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:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips

Automation upgrade

Automation upgrade

RE: automation upgrade

RE: excel 2003

RE: excel 2003

Excel articles

Excel tip:

Using Alt in Save Dialog Box