How do I link to an excel document that does not exist yet?

[Bryan.Pagenkopf]

I need an excel document to have cells that only become active once a document has been created but any time I try I get the #REF error.


Any assistance would be great!

[6StringJazzer]

What do you mean by "link"? There are different types of links. Do you mean an external reference, like

Please Login or Register  to view this content.

but you haven't created 'My other file.xlsx' yet?

Well, yes, a #REF error means "The thing you are referring to doesn't exist so Excel cannot calculate a result." The workaround is

Please Login or Register  to view this content.