linking excel sheets sap
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking excel sheets to SAP

Linking excel sheets to SAP

resolvedResolved · Low Priority · Version 2007

replyReply Fri 23 Sep 2011, 16:07Delegate Jamie said...

Jamie has attended:
Excel Advanced course

Linking excel sheets to SAP

Can this be done?

For upcoming training course dates see: Pricing & availability

replyReply Sun 25 Sep 2011, 21:44Trainer Doug said...

RE: 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


Attached files...

Connecting-to-SAP-BW-with-Excel-PivotTables-and-ODBO.pdf

Sun 2 Oct 2011: Automatically marked as resolved.

 

Please browse our web site to find out more about
excel consultancy and other Microsoft training courses.

Excel tip:

Get back to active cell

If you have scrolled away from the active celland want to get back t it quicly you can Ctrl and Backspace to get back

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard