Referencing Formula on Closed Workbook

Hello Excel gurus,

I wonder if what I'm about to describe is doable.

Say that you have 2 workbooks. ClosedWB and OutputWB1.

In ClosedWB, we have a following formula in cell A1

Please Login or Register  to view this content.

Now...IF IT'S DOABLE, is there a formula where in OutputWB1 it'll take the formula that's in ClosedWB and applies to itself.

i.e. say in cell K10 of OutputWB1, there's a formula that looks at '[ClosedWB]'Sheet1!$A$1, which is =SUM(A2:B2) and then using the formula to sum itself.

If it's not doable. Am wondering if there's any alternatives for it.

The reason why I'm asking is that, we want to create a master template, and that all other Workbooks will get the skeletal of it from the master template. And if there's a change needed to be done, we just have to change it in the master template and it applies to all workbooks that "link" to it. Rather than opening each individual workbooks and make each changes.

@menem Thanks for the solution and even the attached workbooks.

Will try and incorporate this and see how the calculation is going to be. After all, there's a lot of formula that needs to be 'evaluate'

PS: Reps up to you