I have a system of invoicing by making one line of an Excel spreadsheet one
record. A Word document has the mergefields for invoice number, date etc.. In
Office 97 where this system was developed it worked fine. In Office XP, I
can't open the spreadsheet at the same time as the Word invoice page. If I
perform the merge in Office 97 and transfer the files to the XP machine it
works fine. How do I perform a merge in Office XP to keep the Excel data
source open for adding records while stepping through them in Word? Is it
through SQL - and how?

Alan