A non-elegant method:
="='C:\pathname\"&$A1&"\[Workbook"&$A1&".xls]Sheet1'!$D$4"
Copy
Paste as Values
Then I have to click each one and hit enter to update it, because Calculate Now hasn't worked for me.
Still looking for a better way.
A non-elegant method:
="='C:\pathname\"&$A1&"\[Workbook"&$A1&".xls]Sheet1'!$D$4"
Copy
Paste as Values
Then I have to click each one and hit enter to update it, because Calculate Now hasn't worked for me.
Still looking for a better way.
Last edited by cfuqua; 07-11-2012 at 04:20 PM.
Posting Permissions
Reply With Quote