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.

Click here to return to our Support page.

Open a new case

Click here to go to our Support page.

Get detailed answers and how-to step-by-step instructions for your issues and technical questions.

Find and share solutions with our active community through forums, user groups and ideas.

Browse a complete list of product manuals and guides. Available online, offline and PDF formats.

Learn how to master Tableau’s products with our on-demand, live or class room training.