I'm hoping someone can help me out with this. I have a workbook with cell references to multiple sheets in another workbook.
ie. ='Path of workbook\[workbookname.xls]sheetname1'!A1
All the links worked and pulled the correct data when I set them up. However, when I saved, closed and...