Link to excel data

Please help, I am trying to link data from an Excel workbook, In Excel the sheet I want to link to is called Qty Households, when mapoint asks me which sheet or range I want to map it describes it as a named range "Qty Housholds!_" When I click it Mappoint tells me there was a problem opening it???

Hi,

Difficult to say if MapPoint only tells there is a problem without saying what the problem is. Maybe you have it still open by Excel and it is locked ? Just a guess.