if there are a series of references from separate workbooks…

i.e. from A1-100 to B1-100 to C1-100 to D (301 workbooks/sheets in total, for example)… must workbooks B1-100 and C1-100 be opened and resaved to auto-update Workbook D when it’s opened - or when you open up D, will Excel automatically trace all the data back through the other books, even if they haven’t been opened since Workbooks A1-100 have been updated?

if all the books DO need to be opened to update - what workarounds or quick tips might there be to automate or speed up the process, so you don’t have to manually open & resave hundreds/thousands of books?

thanks!!

UPDATE:

Dear community members,

I am new to this community, and didn’t get off to a great start by not clarifying the community rules and making the mistake of crossposting 3 questions in a few other forums.

It was quickly brought to my attention that crossposting is a no-no - and to make up for the error, I immediately updated my posts with an apology and crosslinks to the other posted questions, as per recommendation. I do now understand why the rule against crossposting exists - and I would like to ensure everyone it was never my intention to disrespect anyone’s time or expertise in any way. Ignorance may not be an excuse for my breach of your cultural courtesy - though as I do highly value integrity, I would like to ensure to make up for my error.

As per another recommendation, I’d also like to offer another sincere apology and ask your forgiveness. I do wish to remain in good standing with your community and honor the time and effort you put into serving others through your sharing. And as such, I would like to clarify that to ensure such an error will not occur again, I’ll be limiting my activity to the VBA Express and Excel Forum, ensuring posting one question in only one forum at a time - and if they don’t get answered and I post elsewhere, will ensure to include crossposts in both.

Again, apologies for the disrespect I ignorantly displayed by posting before being clear on the forum rules.

Thank you for your understanding, patience, and forgiveness.

Regards...