Procedure for using the ‘Link to Excel’ option:
Step 1: Right click on the TradeSmart Application and click on “Run as Administrator” .
Step 2 : Kindly Log-In to the application using your credentials.
Step 3: Right click on the Market Watch you want to export and click on the ‘Link To Excel’.
Step 4: Paste it on the required Excel sheet.
If found error of #NA while linking to excel in TradeSmart Desktop Application, please follow the below procedure:
Step 1: Open Excel with admin rights using the following procedure:
- Go to the Start Menu.
- Click All Programs.
- Search for ‘Microsoft Office’.
- Right click on it.
- Select ‘Excel’.
- Go to Properties.
- Click on Compatibility.
- In the Privilege Level, tick mark the “Run this program as an administrator”.
Step 2: After opening Excel with Administrator rights, click on the Office button at the top left corner of the Excel.
Step 3. Click on excel options and select Trust centre
Step 4 : Open Trust centre settings and click on the Trusted locations option on the left side of the page.
Step 5: Go to Add new location and type this – C:\Program Files\Microsoft Office\Office12 OR Office 14>>OK>>OK>>OK
4. Restart excel
5. Open TradeSmart Desktop Application with Administrator rights.