Excel web parts + excel .xlsm files RRS feed

  • Question

  • Hello guys,

    I am trying to display tables and charts created in an excel file (named items) using dashboards in sharepoint.

    Version: Excel 2007 and Sharepoint 2007.

    Everything worked fine until recently, I had to add a small macro to my excel file and that forced me to save it in the .xlsm format.

    I now realize that for some reason I cant show any of the named items anymore in dashboards since SharePoint does not like this file format (which is very surprising).

    Does anyone has any ideas or workaround.

    Also, its sad the 3D charts are converted into 2D. Any ideas to display the charts in 3D? or its not possible at all?




    • Moved by Mike Walsh FIN Friday, July 15, 2011 10:53 AM not a general q (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    Thursday, July 14, 2011 7:21 PM

All replies

  • Unfortunately Excel Services (the service that powers the Excel web parts among other things) does not support running macros. See http://msdn.microsoft.com/en-us/library/ms496823(v=office.12).aspx for more details.

    The way to include macro-like functionality in spreadsheets to be used with Excel Services is to create 'User Defined Functions' or UDFs. There's some info on these at http://msdn.microsoft.com/en-us/library/ms499792(v=office.12).aspx along with some links to a walkthrough.

    Friday, July 15, 2011 10:10 AM
  • I'm wondering about the reply because this post wasn't sent to the Excel Services forum and also because beyond "SharePoint 2007" we don't know which SP product he has.

    Both WSS 3.0 and MOSS 2007 Standard do not include Excel Services


    Moving for now to Admin as this certainly isn't a General question. Will try to move on to Excel Servces if the OP has Enterprise edition *and* feels it should be there.

     P.S. OP: By dashboards do you mean functions of PerformancePoint 2007?




    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Friday, July 15, 2011 10:52 AM