I have been trying to get the formula fill to work across workbooks, but all
it does is copy the cells I am using as a start point. My data source is
nine cell on one work book (1 - 9), and I did a simple =[Book1]Sheet1!$A$1 in
the first cell o fwork book 2, followed by =[Book1]Sheet1!$A$2 and
=[Book1]Sheet1!$A$3 in the next two cells. It worked fine for the first
three cell, but when I tried to use the formula fill all it did was copy the
original three cells. What am I missing?