sharepoint - How can I import data into read-only datasheet fields? -
I am importing the data into the SharePoint list in Excel using "Datasheet View".
When I paste the data, I get an error message "Cell is read only." For the read only field.
Is there a way to import data into the read only field?
As Ryan pointed out, it is not possible to overwrite the results of a calculated field .
My recommendation is to remove the column based on the dateet, then add the columns on which the calculation is based (if they are not already displayed).
You can paste source data for those calculations, automatically populate the results.
Comments
Post a Comment