Hello! I couldn’t find a solution out there on the internet so here I am.
First of all, a very big thank you to LO’s development and support team.
In second place, I am not familiar to accountability jargon so I’ll try to express myself as clearly as I can. Feel free to ask about anything I can’t express correctly.
I have an accountability record that has 13 workbooks: 1 for each month and 1 that works as a Reporting Workbook.
This Reporting Workbook reads from the other twelve workbooks and to calculate the year balance I need read from December workbook. And each month reads from the previous month and provides to the following month. Now we are in June so the following month’s workbooks are empty. So to have the Reporting Workbook updated, I have to open each following workbook, click on update or press F9, save it, and so on…
I was wondering if there’s a way (configuration on a per file basis or plugin or whatever… even writing some code) to have all linked workbooks updated when I open a single one.of this group? I can’t avoid reading December’s workbook to get update info and need December and all the others updated so I can see real numbers while keeping formulas as simpler and not excessively linked and try to keep the number of “helper cells” at the minimum.
I hope I had expressed myself clearly.
Thanks in advance.
PD: LO version: 5.2.7.2