This won't be possible with just the Excel connector. You'll likely need to investigate using "Excel interop" in C#. If you can upload a copy of your spreadsheet, we might be able to take a look to see if there is a way to achieve this without using C#, however I do not believe so based solely on your description.
You might also be able to write a macro in Excel to trigger it. If so, you could call that macro from the Excel connector.