Preserve conditional formatting and sparkline from Excel Services TO Excel RRS feed

  • Question

  • Hello,

    I published an excel 2010 dashaboard that contains some KPI developed with conditional formatting and sparkline.

    The dashboard is correctly displayed in Excel Services.

    But when i try to open the dahsboard in excel 2007 ("export to excel" using Excel Web Access Webpart), i don't see anymore the conditional formatting and sparkline...

    Have you any idea to get around this problem ?

    Is there another method to print correctly the dashboard


    sharepoint 2010

    • Edited by boussarsar Thursday, October 4, 2012 8:54 AM
    Wednesday, October 3, 2012 11:41 AM


  • Problem fixed.

    Sparklines are not supported in Excel 2007.

    But Conditional formatting must be done in Excel 2007 before publishing into excel services...


    sharepoint 2010

    • Marked as answer by boussarsar Thursday, October 4, 2012 12:29 PM
    Thursday, October 4, 2012 12:29 PM