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 » Pivot Tables

Pivot Tables

resolvedResolved · Low Priority · Version 2003

Raj has attended:
Excel Intermediate course
Excel Advanced course

Pivot Tables

Can Pivot tables be programmed via a macro?

RE: Pivot Tables

Hi Raj,


Thank you for your question regarding Pivot Tables.


Yes, PivotTables can be programmed via a macro. We cover this in detail in the Excel VBA course.

Below is a link to the course outline

https://www.stl-training.co.uk/excel-vba-2007.php


I hope this resolves your question. If it has, please mark this question as resolved.


If you require further assistance, please reply to this post.


Kind Regards,


Nafeesa

Microsoft Office Specialist Trainer

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Fri 13 Aug 2010: Automatically marked as resolved.


 

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips


Server loaded in 0.08 secs.