ExcelBanter - Pivot Table data source "data source contains no visible tables"

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pivot Table data source "data source contains no visible tables" (https://www.excelbanter.com/excel-worksheet-functions/47874-pivot-table-data-source-%22data-source-contains-no-visible-tables%22.html)

Jane

Pivot Table data source "data source contains no visible tables"

I'm trying to create a pivot table from an external Excel spreadsheet. Yet
I am getting the following error "data source contains no visible tables".
Any idea what that means? Thank you in advance.

All times are GMT +1. The time now is 07:05 AM.