In this chapter, we connect to the created Payments table from a new workbook under Nick's credentials.
Let's create a new workbook and save it as payments-nick.xlsx.
Then let's run the Data Connect Wizard.
The wizard contains the same connection steps as described above.
Let's connect to the dbo69.Payments table. You can use search. Uncheck Enable Query List on the ribbon.
In this step, you can check the fields to select and the fields to use as filters. We will learn this in the next chapter.
Now you can click OK and insert the table at cell B3.
We have an editable table in Nick's workbook. Alex and Nick can work now in their personal workbooks.
The table has an ugly format, unlike Alex's table. We will solve this in Chapter 7.