More updates from SPC

Steve Tullis & Pej Javaheri presented “Intro to Excel and Excel Services 2010” to a standing room only crowd at SharePoint Conference 2010. Features demo’d include:

  • Excel:
  • Pivot Chart improvements
  • Filter Search
  • Named sets
  • Improvements to conditional formatting
  • Slicers
  • Sparklines
  • Excel Services:
  • Client fidelity improvements & support of new Excel 2010 features
  • (View) Support of workbooks containing images, VBA, etc.
  • Edit & Collaboration in the Enterprise (SharePoint) and in the Cloud (SkyDrive)
  • Leveraging JSOM to create highly interactive dashboards
  • Interactivity, What-if, and modeling inside the Excel Web Access web part
  • Embedding Excel-based content in Office Client applications using REST

Using the Q&A session  – which continued for ~ 15 minutes outside the room during the next presentation – as an indicator, people immediately saw the potential for how their business could be impacted by these products,  and are excited about getting their hands on the beta to try it out.

Office Blogs Comments

Comments: (3) Collapse

  • Can you elaborate on this bullet:

    (View) Support of workbooks containing images, VBA, etc

    Particularly the VBA bit?

    Thanks.

  • Josh: We'll have more information in an upcoming post. The basic gist is that in Excel Services 2007, some files could not be loaded at all if they contained certain features (e.g. VBA, comments, and other things).  In Excel Services 2010, we did some work to "ignore" some of these unsupported features at load time so that the workbook can still be rendered for viewing.  Those features will still not function or render (e.g. VBA code will not execute, comments will not render) but it no longer prevents the rest of the file from loading.

  • Ah.

    I thought from your posting that the Excel Services group had done something really revolutionary re: VBA after telling us for so long that they wouldn't/couldn't.

    Thanks for the clarification.

Comments

Comments: (loading) Collapse