Unanswered: Linking Files
When you have 3 (or more) workbooks linked in "serial" fashion, the links don't carry through as expected.
WorkBook1 A1 = 15
Workbook2 A1 = WorkBook1!A1 = 15
WorkBook3 A1 = WorkBook2!A1 = 15
Change Workbook1 A1 to 25 and save.
Open Workbook3, Update Links, and it stays at 15.
Open Workbook2, update links, and save, then open Workbook3 and it changes to 25.
This is causing problems for my accountants. I supply workbook1 from SQL server. What they do with it from there is their problem. For some reason, workbook 3 is now MY problem too. I told them to link 3 directly to 1, rather than use 2 as an "interim" step, but they didn't buy that. Then I said "Fine, open 2 every day and save it". That didn't go over well, either.
I could write a script to open 2 and save it every night, but there are actually 24 workbook2's. I can see problems happening with that more often than not.
Does anybody have any ideas on another method for doing this?
Inspiration Through Fermentation