Is there a way to make a template in Excel with 'daughter' files that will automatically update if the template is changed?
For instance: I just wrote a fairly simple excel sheet with a number of variables. I then ran that spreadsheet for several permutations of the variables. (Material, length, loading direction, etc.). Well, after running about 100 permutations, I discovered an error in the underlying formulas. Quite upsetting. I'd love it if there were a way to have a 'master' template file where I can fix that one mistake, and the 100 'daughter' files will automatically update and run when I open them.
Pipe dream, I'm sure, but does anyone know of an effective way to accomplish it? Thanks.