<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - External links in Calc via INDIRECT() always require an update" href="https://bugs.documentfoundation.org/show_bug.cgi?id=137541#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - External links in Calc via INDIRECT() always require an update" href="https://bugs.documentfoundation.org/show_bug.cgi?id=137541">bug 137541</a> from <a class="email" href="mailto:torgeriedel@gmx.de" title="Torge Riedel <torgeriedel@gmx.de>"> Torge Riedel</a> <pre>Thanks for your answers. Let me explain my scenario a bit more: I have several Calc files each of them contains data for a specific year (2020, 2019, 2018, ...). They are all linked, cause sometimes data needs to be adjusted in - let's say 2018 - so Calc files for 2019 and 2020 needs to updated. In this case I opened the files 2019 & 2020, clicked on "Refresh / Update" and the whole file is updated with the new data from the links. Afterwards I saved them. If there were no changes in older files I was able to open the file for 2020 without the need to click on "Refresh / Update" and work with that data. This was possible as long as I used a 6.2.x version and it could be that it was not the latest patch version, but the one before the changes were implemented. Now, when I open the file for 2020 it is flooded with "540" errors and I always have to "Refresh / Update", otherwise it is impossible to work with the file. And the refresh takes a while. There are 10 files involved. Several years ago I used the function DDE(), but switched to INDIRECT() cause it is (was) more flexible. Now it is unusable for me. @Eike: You mentioned "..., contrary to direct external references, ...": Is there another way to link data from the files including caching? The challenge is: I have lots of external references in the file and when a new year starts I save 2020 file as 2021 and with INDIRECT() I only need to change the value of one cell in the table to switch links from 2019 to 2020. I fear this is not possible without INDIRECT().</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>