Fill function with file reference

C

Compu Geek

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with SET & REF function 0
Extend formula row reference across columns 1
Large Excel 2008 .xlsx file behaviour with Vista 3
Macro 0
Fill Series for Lookup 2
problem with formulas 5
SUMIF function and cell /sheet reference 3
Autofill 3

Top