A new field in inventtable is added. I tried to update the new field data through excel add-in but the records did not get published by throwing an error message that the items already exist rather than updating the existing record.
Is excel add-in only for insertion and not for updating existing record?
Is there a way to update the new field data ? There are 1800 records to be updated.
Yes ..you can update the table records using Excel add-in...
Please refer this link...
If it throws the error like "record already exists"... Check all the related tables
I tried but did not work out. Also I am not able to do debugging from excel add-in. So not sure from where the validation is initiated.
can some one guide me how to do debugging from excel add-ins?
When excel add-in tries to publish, could someone explain which AOT object will be initiated and where should the breakpoint must be set to initiate the debugging?