Retrieving values from different workbooks

[kdr]

I have multiple workbooks that I'd like to pull only bits of information from, like totals. When I try to pull a total I've been using =[PracticeTemplate]Sheet1!E7 which comes up with a value of '0' and the actual value in the original workbook is '31'. What am I missing?

Would an update automatically happen when a workbook is opened?

 

[id107]

Try using the whole path:
='C:\Path\To\File\[PracticeTemplate.xls]Sheet1'!E7

 

[kdr]

You know what...I tried that, and got an error dialogue box; BUT, I triple checked the formula and low and behold it worked! Seems I needed to select the cell when it verified my filepath, not just type in the cell I wanted. Either way, I have a solution to that little issue!

Now, how do I get the workbook to update when the original cells change?