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

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.?

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.