How can I import data into read-only datasheet fields?

1.3k Views Asked by At

I am importing data from Excel into SharePoint list using the "Datasheet view".

When I paste the data, I get error message "Cell is read only." for read-only fields.

Is there a way to import data into read-only fields.?

1

There are 1 best solutions below

0
On

As Ryan mentioned, it isn't possible to overwrite the results of a calculated field.

My recommendation would be to remove the calculated columns from the view the datasheet is based on, then add the columns the calculations are based on (if they're not already displayed).

You can then paste the source data for those calculations in, automatically populating the results.