Excel Import external data

Version: Excel 2003

Setup a .xls file (Book3) to import data from another .xls file (Book1)

Book3.xls worked fine, importing data from Book1 until another column was added to Book1.xls subsequently to Book3.xls.

Added requested column via tools/import external data/edit query.

Verified data is present in newly added column in Book1.xls.

Book3.xls does not import the data from Book1.xls (although it successfully imports
the data from the columns that were previously setup prior to adding the additional column.)

Do I need to change my query, tables, data ranges? If so how?

Am not a wizard with Excel any assistance would be appreciated