This error does not necessarily mean that it doesn't like the format of the file path. When reporting an error please provide more context. What is the actual formula you are using? Some Excel functions return a #REF error if the referenced workbook is not open.