98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba training - Pivot Tables
excel vba training - Pivot Tables
Resolved · Low Priority · Version Standard
Brad has attended:
Excel Advanced course
Pivot Tables
How do I link these to data in third party programs?
RE: Pivot Tables
You need to be able to connect to the 3rd party data as a DATA SOURCE.
Use DATA > IMPORT EXTERNAL DATA > IMPORT DATA
This will list all the data source names.
Create a new one, by clicking on the top of the list, and identifying the
NAME
DRIVER
DATABASE LOCATION
If all of those are successful, then you can use the source to create a pivot table, by choosing EXTERNAL DATA SOURCE on the first step of the Wizard
Regards
Richard
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Use Paint Brush to Format More than one CellTo copy a format to many cells or ranges |