Is there a way to allow an excel document to run a macro when a excel file is opened from SharePoint 2010?
I'm trying to embed a chart on a quick lookup excel doc from a list hosted in SharePoint but the field I am using to create the chart is not aggregating the numbers because Excel thinks it's just text.