I want to create an external reference to cells in an Excel spreadsheet named
When I enter the formula
=[Employee Data.xls]sheet1!A1, I keep getting the error "The name that you entered is not valid. The name contains a space or other invalid characters".
I've tried a few different formulas, including:
The only "solution" I've found is renaming the file to remove the spaces (i.e.
How can I reference an external file in Excel if the filename contains spaces?