Purpose

This article covers the installation and use of the Excel Add-In to set up 1010Data access authentication through Ping


1010data Add-In

Instructions on updating the Excel Add-In for 1010data

Prepared by the Save Mart Business Analytics Team | Updated August 2021

  1.    Updating the Add-In

To update the 1010data add-in, follow the steps below.

  1. Close Microsoft Excel completely
  2. Open Google Chrome
  3. Go to this website:  https://www.1010data.com/support/technical-interfaces/excel-add-in/
  4. Click the .exe link for Add-in 2.0 for 64-bit windows

       5. The file will download and be shown at the bottom of the Google Chrome Screen: 


                                         


      6. Click this downloaded file

      7. Choose Run

      8. Next you will see the Add-In Wizard – click Next

9 When prompted to accept the license, scroll to the end of the license agreement, select “I agree . . .”, then click Next

10. If you receive this message: “An existing instance of the 1010data Excel Add-in has been found on this computer at (some path listed here).” Click OK.

11. Click Next/Ok/Finish until you get to the end of the install wizard

12. Open a blank Excel file

13. Go to the Add-Ins tab at the top of the screen

14. Click the 1010data drop-down

15. Click Login



16.    The new login screen is shown below

a.    Set the environment to: https://savemart.edge.1010data.com

b.    Under Authentication set it to PingOne

c.     Username will be your employee ID

d.    Password will be your Windows/Ping password