Applies to: Excel 2007 .xlsx files
You add an Excel 2007 .xlsx spreadsheet to a project and try to extract data from it to a project report. You receive and error message such as:
No worksheet with this name was found in the workbook.
This may be caused by 'phantom' links to other Excel workbooks that are not open or available. This can occur for a number of reasons, mostly by copying worksheets or blocks of cells from one workbook to another.
Also you should check for explicit references in formulas to other workbooks by searching for '[*]'