Dec 03 2021 03:44 AM
Hello
I tried looking for a solution to my problm but no luck. When trying to link a cell from different workbook I used the =cell adress method. It work when both workbooks are opened but when I open just the destination workbook the data shows error and in the formula the name of spreadsheet in source workbook is missing.
Both workbooks are in the same local disk but different folders. Manually changing the missing name fixes the issue but doing that everytime defeats the puropse of spreadsheet. Thank you for any response
Dec 03 2021 04:03 AM
SolutionDec 06 2021 01:26 AM
Thank you. Changing the safety setting solved the problem
Dec 03 2021 04:03 AM
Solution