5_2:problem_reading_data_from_excel_spreadsheet

KB0009016 Problem Reading Data from Excel Spreadsheet

Applies to: Excel .xlsx files

Symptom

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.

Cause

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.

Solution

  1. Select the 'Formulas' ribbon then 'Name Manager'
  2. Under 'Defined Names', check the 'Refers To' column to make sure none of the names are referencing a different workbook.
  3. Delete unwanted references.

Also you should check for explicit references in formulas to other workbooks by searching for '[*]'

5_2/problem_reading_data_from_excel_spreadsheet.txt · Last modified: 2019/03/03 07:49 (external edit)