Excel file not found copy from error
CompletedI have a an exernal named range shown below which cant find the file although the same format for other files can be found. I get an error message asking me to copy from another location, i point it to that location and the data is returned. I don't want to have to 'find' the location of the file each time. Some files are 'greyed out' and it might be only occurring for greyed out files but I cant be sure. Can someone assist in a solution?
WARF |
='/Users/andyseaman/Library/CloudStorage/Box-Box/16. Big data/2. Data/Daily Extract (Latest)/KVW Latest.xls'!WARF
|
Please sign in to leave a comment.
Comments
1 comment