I have a problem related to external data in excel This is an example of what I have done:
Index (Book) Painel (sheet) - I enter data in the panel that will be sent to another book (count) sheet (sum) and will receive the data coming from it.
Contagem (book) Soma (sheet) - computes and sends the result to Book ( index ) sheet ( painel ).
The question I have is that whenever I want to update this data I have to have both excel open and wanted to know if there is any way to do it with just the book ( index ) open and the book (% with%) closed?