Question: how to import data from one workbook to another workbook in excel 2007?
Answer: #2 click Add button in the Workbook Connections dialog box, and the Existing Connections dialog will appear. #3 click Browse for More button in the Existing Connections dialog. And the Select Data Source dialog will open. #4 select another workbook file that to be imported in the Select Data Source dialog box.