KNOWLEDGE BASE

When Connecting to Sample - Superstore, 6 Sheets Are Displayed in The Connection


Published: 24 Sep 2019
Last Modified Date: 27 Sep 2019

Question

When connecting to the Tableau example data source, which is an Excel file called Sample-Superstore, six work sheets are displayed in the data source connection. However, there are only three sheets in the Sample-Superstore Excel file.

Environment

  • Tableau Desktop
  • Tableau Prep
  • Excel (Sample - Superstore)

Answer

The Sample-Superstore Excel file contains some Named Ranges, which causes the data content to be split up in more work sheets.
To prevent this behavior, delete the Named Ranges from the Excel file, then reconnect Tableau Desktop / Prep to it, now you should only see 3 sheets.
Did this article resolve the issue?