Forum Discussion
Automatic updating of two excel sheets which are connected by formulas and tables
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 DTE, I see your advice is professional.
The solution demands our company to work with excel on a much higher level as now.
The task for me ist to build up PowerQuery. It will be a lot to bring my colleagues to understand and accept new quality of using excel and me to program it flawless.
But thats the reason I like this comment - it´s a kick in the **bleep** to improve!
Thx 😉
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/
😉
