0

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.

enter image description here

marked as duplicate by Eric Alexander Jan 13 '17 at 22:28

This question was marked as an exact duplicate of an existing question.

  • Do you have a macro that already works when you open Excel outside of SharePoint? – jpollar Jan 13 '17 at 20:40
  • @jpollar I actually don't have anything that works at this time. – Kenneth Kerr Jan 13 '17 at 20:45
  • You have to walk before you can fly. lol The best way to do this would be with a pivot table anyway. You know how to do those? – jpollar Jan 13 '17 at 21:18
  • @jpollar I think I miss understood your question. This is already built out as a pivot table. Still only allows me to see true numbers if I click in the cell and hit enter to actually receive it from SharePoint as a int. From SharePoint the numbers in column C aren't truly numbers read by Excel until I click into the cell and hit enter. When the form goes and gets refreshed data it all reverts back to non numbers. – Kenneth Kerr Jan 20 '17 at 16:39

Browse other questions tagged or ask your own question.