Connecting multiple excel documents/cells

Question

I am trying to connect multiple excel files and create a two way connection between documents.

The purpose is to have two connected documents that will be updated if the data in certain cells changes, this has to work if something is updated in the master document and the secondary document for the same cells.

Excel does not like it when a loop is created between cells, is there a way to do this within excel or through the use of something like Power automate?

Answer 1

Hi, SimeonRR

Thank you for using Microsoft products and posting them to the community.

Currently Excel does not directly support bi-directional connections, and the most convenient way to do this is really to use Power Automate or Power Query.

However, the technology about Power Automate is beyond the scope of support of the Microsoft community, but Power Automate has a special community, you can go to that community to re-post a thread.

Here is a link to the forum where you can raise specific situations and share your ideas to help solve the problem.

Forums | Microsoft Power Platform Community（English only）

Sincerely hope that your question can be properly handled after contacting the right department. Thank you for your understanding!

If you need further help, please feel free to reply.

Thank you for your understanding and patience, I look forward to your reply.

Aiden.C - MSFT | Microsoft Community Support Specialist