Question

Simon is having trouble using linked workbooks, so he cousults his colleague Brooke for help Finally, Simon asks Brooke what steps (if any) need to be taken to keep a destination file up-to-date if he updates a value in one of the source files Which of the following statements by Brooke would be correct? O a If a destination file is ope when a source file is changed the destination file will be updated automatically Ob Source files cannot be updated unless the corresponding destination file is open c. It is not possible to choose whether a destination file should reflect changes made to the source files. Od If a destination file is open when a source file is changed, you need to update the destination file manually so that it reflects the changes,

Answer 1

Option A. If a Destination file is open when a source file is changed, the destination file will be updated automatically.

It doesn't mean that the destination file should be open when there is any changes are made to source files.

The Destination files should be updated automatically when there is a change in source files whether it is open or not.