When you create a new script, you can edit the data file.
You can open an existing data file before you start recording, or from the Data Set panel on the Map tab.
If you are unable to open the file, add the Evolve site to Trusted Locations.
You can open existing data files that contain Excel formulas and drop-down menus (data validation). You cannot add or change the formulas or menu choices while Studio is open, but you can change them later in Excel.
If the file contains PivotTables, 3-D charts, or custom XML, it opens in read-only mode. If you click Enable Editing, they will be removed.
- Open the data file in Excel to enter any data that is needed, and then close the file.
- Open the script in Studio.
- Validate the data.
- Click Run. The data file opens in a separate instance of Excel and the data is uploaded to SAP.
Note: If you open the file in Excel and it is already open in Studio, the file will open
in read-only mode.