Can multiple spreadsheets be linked to change simultaneously?

[botha822]

I work for a financial services firm and we create template spreadsheets
for many different markets. Many times we need to make a formatting
change, add a new column, or change a formula. When we do it in one we
want to have the same change automatically carried over to all of the
workbooks. Each sheet has the exact same format (same formulas, # and
placement of columns/rows, and same data types in each column row), but
it is very time consuming to alter each sheet separately. Any advice?

 

[botha822]

To clarify, it would be like a dynamic template, where once changes wer
saved to the template, the rest of the spreadsheets would update

 

[Dave Peterson]

Excel is more of a Pull system. You can use formulas to pull information from
one location to another.

It's not a very good "Push" system where changing one cell would push that same
change to lots (or even one) other location.

My suggestion would be to put the data in one location and then use other
techniques to get the various workbooks/worksheets you need.