Data source contains no visible tables

I believe this has started after redoing a macro linked to this excel spreadsheet.  Now when I open this spreadsheet I get a blank sheet with "data source contains no visible tables".  If I select Ok the spread sheet will open.