Jean Paul's Blog

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

    Advertisements
  • 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
  • Advertisements

Incompatible Workbooks

Posted by 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.
Advertisements

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