Is there a work around in importing Excel Spreadsheet data (copy and paste) into Datasheets with calculating columns? For some reason, when I import it, the calculating column doesn't populate and it's a read only datasheet column.
Sounds like you could manually copy the calculated column data from Sharepoint to Excel instead? (Unless you have so much data that this would be impractical).
Otherwise you could recreate the calculated column in Excel. The problem with calculated columns is that they need all the columns used in the calculation to be present; when the data is sent to Excel you are losing this calculation since Excel is a different application to Sharepoint.