1st, forum rules require that you wait at least a day before bumping your thread. Also, many members will only look at threads with 0 replies - by bumping, this thread already has 1 reply.

OK, if you are trying to share this file - or its contents - with others across a network, then unless they have access to the hard drive on YOUR machine, that formula will never work for them.


C:\payroll\Monthly Reports\June 15\[Annual Leave June 2015.xlsx is a path to a folder on YOUR machine on YOUR C-drive. If you need for others to have access to that data, you need to put it on the network where they can access it. Even if you email that file, it will still point to a file on YOUR machine, which they will not have access to