Open each spreadsheet in a new instance of Excel 2010

To resolve this, go to ‘excel options’ > click on the ‘advanced’ tab > scroll down to general > check the ignore other applications that use ‘Dyanamic Data Exchange (DDE)’

more info here