It should be provided you quote the full path name of the source Workbook.

For a simple example go to:-

http://www.pierrefondes.com/

Scroll down to item number 47 where you will find 2 Linked Workbooks.

If you pull these up on your screen (both at the same time) update cell A1
in avinity1.xlsx and you will see A1 in avinity2.xlsx update automatically.

Just examine A1 in avinity2.xlsx to see how the data is pulled from the
other Workbook.

In your situation you just need to make sure that the full path name of the
source file is quoted, for example, in cell A1 of avinity2.xlsx.

Please hit Yes if my comments have helped.

Thanks.



"Hoov" wrote:

I have two different excel documents. One is called "Job Costing" and the
other is the "Project Book". I update the Job Costing sheet daily, and then
I put the total from that sheet onto the Project Book when that particular
job is finished. It would be extremely helpful if the Project Book could
update automatically each time that I update the Job Costing sheet. However,
these two documents are on two different folders on our server, so I'm not
sure if that's possible. Is it?

Thanks so much!

Aaron