Hi

I am Zuber Agwan , recently i have gone through some limitations in using MOSS 2007 Excel Services so i thought to share it with you all for a sake of information

this is the detailed description on moss 2007 excel services unsupported features

The unsupported features are grouped into four different categories to make it easier to discuss them. The four categories are as follows.

Features that Prevent Excel Files from Loading

In some cases, when Excel Services does not support an Excel 2007 feature, Excel Services will not load the file. For example, Excel Services does not support running Microsoft Visual Basic for Applications (VBA), so it will not load files with VBA in them.

Features that Are Not Displayed

In some cases, Excel Services does not display an object in a workbook that has full fidelity with Excel 2007. For example, charts in have new visual effects, but those effects are not visible when viewed using Excel Web Access.

Features with Limited Interactive Support

Not all features that you can interact with using are fully supported in Excel Services. For example, users cannot add or rearrange fields in PivotTable reports when working with workbooks in a browser.

Authoring Workbooks

You cannot author an Excel workbook using Excel Services. This means, for example, that you cannot insert a chart or change a formula once the workbook is opened in Excel Web Access.

Features that Prevent Excel Files from Loading

Excel workbooks that contain or use one or more of the following features will not load in Excel Services.

  • Code. This includes workbooks with VBA macros, form controls, toolbox controls, Microsoft Excel 5.0 dialog sheets, and XLM macro sheets.

Note:-Excel Services supports user-defined functions that are written in managed code. Native code add- ins like XLL files are not directly supported. However, you can use “wrappers” to call the native code functions.

  • Information Rights Management (IRM) protection.
  • ActiveX controls.
  • Embedded smart tags.
  • PivotTables report with multiple consolidation ranges.
  • External references (workbooks that contain links to other workbooks).
  • Workbooks saved in formula view.
  • XML expansion packs.
  • XML maps.
  • Data validation.
  • Query tables, SharePoint lists, Web queries, and text queries.
  • Workbooks that reference add-ins.
  • Workbooks that use the RTD() function.
  • Workbooks that use workbook and worksheet protection.
  • Embedded pictures or clip art.
  • Cell and sheet background pictures.
  • AutoShapes and WordArt.
  • Ink annotations.
  • Organization charts and diagrams.
  • DDE links.