In normal Excel, when I create 2 workbooks and load values from the second workbook (for example, MY DATA) into one workbook (for example, MAIN1), using the command:
='C:\!!! BUSINESS !!!\!!!RP DNA link to price list\Versions\MY DATA\V1.77\[MY DATA.xlsx]PROF4'!$C$3
So the changes made in the MY...