Sometimes you have a worksheet but it is connected to the wrong datasource. You cannot use Replace Datasource to switch its datasource as this causes other problems (eg for the existing sheets that you want to remain connected that way). So rather than rebuilding the worksheet from scratch based on the new ds there is another way involving cheating. You basically copy and paste that sheet into another workbook and do the Replace Datasource there. Then you can bring it back into the existing workbook. Seems to work !