Hi,
It's been a while since this question was posted, so hopefully an answer has been provided to you by ClientCare by now.
The use of cell formulae containing 'Named Ranges' in the Excel workbook generated the same error (error code 7002). It's not exactly clear why this occurred, but replacing these named ranges with a cell reference worked.
Best Regards,
Alex @abanalytics