Forum Discussion
Solved
Automatic updating of two excel sheets which are connected by formulas and tables
Hello Excel-experts, have a good pre-xmas-time! My issue: I have two excel files: mappe1.xlsx and mappe2.xlsx Both have tables are linked by xlookups (by names, not by numbers like a1:a10) a...
Hi DrJedi
I promise you will get a return on the time invest to learn Power Query very soon!
And it's not very difficult to start with it.
If you are interested, you will find some introduction here:
https://www.tabellenexperte.de/einfuehrung-in-power-query-teil-1/
https://www.tabellenexperte.de/einfuehrung-in-power-query-teil-2/
😉
Hi DrJedi
it's just not possible to update such formula links in the background, when the linked file is not open.
I generally advise users not to create formula links between different workbooks, as this always leads to trouble sooner or later.
Instead, I propose to create a connection with Power Query. Once that is in place, you can do you updates in the background without opening any other files.
Hi Martin_Weiss,
Thank you for this - I need to be able to adjust an input cell in File 1, which flows and affects File 2 - and then the adjusted result flows back to File 1. I need the functionality to allow File 2 to change automatically in the background and then the adjusted result to flow back to File 1 - all without opening File 2.
Is this possible using Power Query? Or any other functionality?
Thanks!
Jaco
Thank you for this - I need to be able to adjust an input cell in File 1, which flows and affects File 2 - and then the adjusted result flows back to File 1. I need the functionality to allow File 2 to change automatically in the background and then the adjusted result to flow back to File 1 - all without opening File 2.
Is this possible using Power Query? Or any other functionality?
Thanks!
Jaco