a Co worker asked me for helpon this one and I'm at a loss on this one.
Working with linked files, not using a macro to link but a straight = to the target workbook info, the target file cannot be read if not open at the time. Re-linking brings back the 'cannot find file' message which is amazing since we are looking at the file at the time.
We are in Excel 2007.
Any ideas, anyone?
Working with linked files, not using a macro to link but a straight = to the target workbook info, the target file cannot be read if not open at the time. Re-linking brings back the 'cannot find file' message which is amazing since we are looking at the file at the time.
We are in Excel 2007.
Any ideas, anyone?
