I have set some simple reference formulas to other worksheets, when other
users open the files, it cannot find some of the reference files. The only
difference in the formulas between the ones it finds and doesn't are that the
drive and filename are in capitals [I have no idea why]. Also, it doesn't
allow me to change this and when I try, it just defaults back to lower case.

Any ideas why this is happening and why it is messing with the references?