Linking excel sheets to SAP

Hi Jamie

Good to meet you on Friday. I wasn't able to demo this on your Excel Advanced course. But Excel can definitely connect up with a SAP data source for pivot tables and running queries.

I've attached a pdf file with instructions for creating an Excel pivot table from a SAP data source. It contains how to include a login password which you asked about.

Hope that helps.
Regards
Doug