Forum Discussion
Very Weird problem might not have solution with VLOOKUP
I pull metrics for over 100 different names from two different workbooks, I use VLOOKUP to pull these from the multiple sheets in the workbooks. The sheet names never change but the file names will c...
Go to Data | Edit Links - locate the source workbook, choose 'Change Source'. Navigate to the new workbook to update the link.
Thank you did not know that would work. Is there a way to change it for one individual sheet instead of the whole workbook. like sheet1 linked to workbook 1 but when i duplicate the formula it will still be sheet2 linked to workbook1 but sheet2 needs to be workbook2.