Hi there,
Any help with this one would be much appreciated!
I have a link to a cell in an external workbook: ='D:\Finance\[cashflow.xlsx]Cashflow'!A1
When I copy that link down or across, the formula updates (i.e. A1 becomes A2 etc) but the link does not work and the value is given as zero.
If I then put my curser into the formula bar and hit enter, the file selector dialogue box appears. If I then select the file (cashflow.xlsx) and hit enter, the formula then gives the correct value.
However, I can't do this for hundreds of cells.
Why doesn't the formula just copy across/down as I would expect it to? Why does the link to the external workbook get broken?
Thanks!
Any help with this one would be much appreciated!
I have a link to a cell in an external workbook: ='D:\Finance\[cashflow.xlsx]Cashflow'!A1
When I copy that link down or across, the formula updates (i.e. A1 becomes A2 etc) but the link does not work and the value is given as zero.
If I then put my curser into the formula bar and hit enter, the file selector dialogue box appears. If I then select the file (cashflow.xlsx) and hit enter, the formula then gives the correct value.
However, I can't do this for hundreds of cells.
Why doesn't the formula just copy across/down as I would expect it to? Why does the link to the external workbook get broken?
Thanks!