Hi

We are working on a requirement to automate complex excel sheet(with macros) based business logic to a web enabled solution.
SharePoint 2013 excel service based solution has been considered for this scenario. We are passing excel input parameters using excel service RestAPI and getting the output from corresponding cells using the same URL. However this approach works fine for a simple excel sheet with macros and formulas. However for a complex spreadsheet with complex macros, RestAPI call is throwing 502 error.

Can some one provide pointers on the limitations of Excel complex macros on SharePoint excel service context please?

Thanks & Regards

Roy

Hi Roy,

Please try to use the complex spreadsheet(without macros) to test whether it works.

Or check the unsupported Features in Excel Services REST API as below:

https://msdn.microsoft.com/en-us/library/office/ff394477.aspx?f=255&MSPPError=-2147217396

If the issue still exists, I suggest you use Fiddler to check the requests and responses message.

Best Regards,

Dennis

Hi Dennis,

Thanks for finding time to reply. In fact we have already tried the options which you suggested.

I think I wrongly mentioned macros instead of UDF's as macros are not supported in sharepoint excel services. Sorry for confusing.

We concluded that the issue was due to timeout as the excel service was talking more than 4 minutes to complete the process . The timeout was happening in a reverse proxy server which we identified later.