Hi,

I’m working on quite huge spreadsheets. The same formula will be used on more than 30 sheets.

So far if I have to change the formula in one cell I have to go to each sheet and change it manually (which is quite boring and time consuming).

I’m wondering if it’s possible to reference all the formulas on the sheet to one sheet (which some kind of a master sheet with all the formulas).

I can copy the formula with the “Past Special” function but the function is not updating if I change the formula on the main sheet.

So is it possible to link it and that it’ll be updated automatically when I’m changing the formula on the main sheet?

Thx for your help!

Martin

I’m working on quite huge spreadsheets. The same formula will be used on more than 30 sheets.

So far if I have to change the formula in one cell I have to go to each sheet and change it manually (which is quite boring and time consuming).

I’m wondering if it’s possible to reference all the formulas on the sheet to one sheet (which some kind of a master sheet with all the formulas).

I can copy the formula with the “Past Special” function but the function is not updating if I change the formula on the main sheet.

So is it possible to link it and that it’ll be updated automatically when I’m changing the formula on the main sheet?

Thx for your help!

Martin

## Comment