Hey there! Question for everyone.

I have two users - Fred and Bob. They use different computers, but they have an Excel sheet on a shared skydrive.

I'm trying to reference another shared spreadsheet from within my spreadsheet. For example, test1.xls's cell A1 should reference cell A8 in an entirely different Excel file in a different location (but same shared drive).

I know I can reference it for one user, but when the other user launches the file, it says woah, we can't find this data because the path is wrong. If Fred opened it, it's looking in C:\users\Fred\skydrive\etc etc. But when Bob opens it, it can't find Frank because he's on a different PC.

Windows environment variables don't seem to work in Excel. Is this going to work?