Hello
I've created date connection to my sheet which simply an existing excel file.
I need to modify that file to get the updated records in my sheet.
The problem that i need to close my sheet before i modify the existing excel file.
Is there a way to modify the source (The data connection file) while my sheet is active?
I've created date connection to my sheet which simply an existing excel file.
I need to modify that file to get the updated records in my sheet.
The problem that i need to close my sheet before i modify the existing excel file.
Is there a way to modify the source (The data connection file) while my sheet is active?
Last edited: