I have 2 workbook.
1. Ipe.xlsb
2. Masterfile.xlsx
I have the follpwing formula on Ipe.xlsb]B1
='H:\Prod\[Masterfile.xls.xlsx]Sheet1'!A2
it is not updating unless I press F2 and update it manually.
Is there a way to update the link automatically? Or is there another formula that I can use to make it work?
1. Ipe.xlsb
2. Masterfile.xlsx
I have the follpwing formula on Ipe.xlsb]B1
='H:\Prod\[Masterfile.xls.xlsx]Sheet1'!A2
it is not updating unless I press F2 and update it manually.
Is there a way to update the link automatically? Or is there another formula that I can use to make it work?
