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

[Jane]

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.