I want to fill across a row using the pattern:
='Q:\DATA\[TestBook1.xlsx]Sheet2'!$A1
='Q:\DATA\[TestBook1.xlsx]Sheet2'!$B1
='Q:\DATA\[TestBook1.xlsx]Sheet2'!$C1

etc.

I don't have access to this Q drive, but I need to update the workbook. The
problem is that a popup appears every time I try to drag the autofill handle,
and it won't let me continue dragging. What can I do to autofill across
multiple cells? How can I get rid of the popup?

I'm using Excel 2007.