This guide shows you how to use events to load transactional data
Working with events in the Excel Add-in