Updating an Excel workbook that has data validation with Nintex (Excel Web Services)

  • 26 September 2017
  • 1 reply
  • 5 views

Badge +8

I have a workbook that I would like to populate with some list data.  I only need to populate a couple NON-VALIDATED cells.  The workbook has some validated cells in it, and I'm getting this error :

Error returned from server: <soap:Fault xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><faultcode>soap:Server</faultcode><faultstring xml:lang="en-US">This workbook cannot be edited because it contains the following features: • Data validation To edit this workbook, open the workbook for viewing, select Save a Copy from the File tab, and edit the new copy.</faultstring><detail />
Are there any workarounds or other ways I can write data into this sheet from the list while maintaining the validation?

1 reply

Badge +9

Editing such a worksheet with excel online or excel web services is not supported. See

Excel Online Features | Office Online Service Description 

Reply