Linking Excel Cells Bi-directionally between two or more excel files

(0) Share

Report

Posted on by SR-07110754-0

Hello,

I am trying to link data in two excel files, the data should always be the same but able to be changed in either excel file.

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

Is there a way to automate this with power automate in a way that can be applied to a large number of cells?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

David_MA 13,491 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What you're asking to do isn't really a Power Automate feature. You would do this in Excel: How to Sync Data Across Microsoft Excel Documents. If you have trouble with it, you should post it in the Excel community forums instead: Excel | Microsoft Community Hub

Was this reply helpful? Yes No
SR-07110754-0 4 on at

Like (0)

Report
Copy link

Link copied!

@david_MA thank you for the response but that doesn't help because i need it to be bi-directional which is something excel doesn't support by itself.

Was this reply helpful? Yes No