I have made a Dynamo script that exports data to a separate tab in Excel (let’s say tab1;celA1). In Excel I cross reference this value to another cel in another tab (tab2;celA2).
Now when I re-run my script it looks like Dynamo deletes tab1 so tab2;celA2 does not have a reference anymore (#NB) and then again it creates the tab1 with the exported data to cel A2. But the cross-reference tab2;celA2 stays lost.
How do I fix this so that the cross-reference stays intact? Or is there a way so that Dynamo does not first delete the tab but only refreshes the data input in the tab?