Retaining Formula

[Erika Schwartz]

I need to create a formula in a cell that refers to data in cells in "Sheet1"
and "Sheet2". However, these two sheets will not exist when I save
the original worksheet with the formula in it. The sheets will be
variable and will be added later. How can I save the formula even
though the worksheets referenced aren't really there?
Erika S.

 

[Quido]

You can create the formula manually, for example:
=Sheet1!A1:C10
Excel may have some objections before saving the file but you can easily
cancel those warnings and proceed. The same applies to opening the file once
again. However, the cell will display a #REF! error message, naturally.
Hope this helps you

I need to create a formula in a cell that refers to data in cells in
"Sheet1"
and "Sheet2". However, these two sheets will not exist when I save
the original worksheet with the formula in it. The sheets will be
variable and will be added later. How can I save the formula even
though the worksheets referenced aren't really there?
Erika S.