I would like to set up an automatic live or refreshable link to a salesforce report from Excel so Excel can always have the latest data in Salesforce.
3 answers
@Douglas Harris - This is native to Excel - depending on your org's security persmissions. Open MS Excel, go to Data -> Get Data -> From online services -> From Salesforce reports (or Salesforce objects)
In excel - you just refresh data - and Boom!
