Suggestion: I think that Primavera isn't useful to import sheets from excel directly
When I need to do that, first I create a standard bank of resoucers in Primavera without altering the resources properties. So, export the project with resourcers base from Primavera to Excel. Make all the changes you need in excel (preserve excel format) and after that go back to Primavera with the Resoucers. Attention with the exchange rate.