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?