Welcome to MSDN Blogs Sign in | Join | Help

Microsoft Excel

The team blog for Microsoft Excel and Excel Services.
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.

Posted: Wednesday, October 21, 2009 3:33 PM by Joseph Chirilov

Comments

Josh said:

Can you elaborate on this bullet:

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

Particularly the VBA bit?

Thanks.

# October 21, 2009 4:46 PM

Joseph Chirilov said:

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.

# October 21, 2009 5:47 PM

Josh said:

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.

# October 21, 2009 6:01 PM
New Comments to this post are disabled
Page view tracker