Edit: I am going to export the table, make the necessary changes, and dataflow it in again.
I have a table in Dataverse with more than 40,000 rows of data.
We have spent months importing the data into this new system. Only to realise now, I made a huge mistake on one column. All the values were imported as positive numbers, where some should have been negative. To isolate the ones that should change is easy, but I can't find a way to update the data.
I tried to 'edit in excel' but after I made the necessary changes, I can't publish. I get an error: "Could not retrieve new data from workbook".
Please give me some advice - I have no idea how I am going to fix this.

Report
All responses (
Answers (