Read only when opened

[tawnee jamison]

I have an invoice template that is used on several different types of charges. It reads other open excel sheets.

The problem I'm having is that information remains from the other sheets, even after they have been closed.

My question is: Can I have the information dissapear after the source sheets are closed?

Thanks in advance, Tawnee.

[tawnee jamison]

Has everyone given up on this one....please help!!!


Tawnee.