Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand

Incompatible Workbooks

Posted by Jean Paul on February 25, 2015


While working with Excel Workbooks using Excel Services, we may encounter Incompatible scenarios like below:

  • Workbooks with Macros
  • Workbooks with VBA
  • Workbooks with External File References

Following are the measures used to deal with such incompatibility:

  1. Simple Remove incompatible features, save the workbook & re-upload to SharePoint
  2. Medium Introduce UDF (User Defined Function)
  3. Complex Following are the complex approaches:
  • Convert Macros to Formulas thus persisting the functionality.
  • Server-Side Programming Use programming behind the scene  to modify the cell values which originally was managed through Macros/VBA.
  • Client-side Programming for modifying cell values using JavaScript
  • Web-Services for doing back end calculations.  Client side scripts should invoke these services.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s