![]() Each kind of data source has a different dialog box. This is the same dialog box you see when you first imported the data. To change a data source, select it, select Data Source, and then make changes in the dialog box for that data source. If there are many data sources, enter a search phrase in the Search data source settings box or select the Sort button on the right to sort by the name or kind of data source. Global permissions To change permissions for all your workbooks. ![]() In Excel Select Data > Get Data > Data Source Settings.ĭata sources in current workbook This is the default option and it also displays the Change source button at the bottom. In Power Query Select File > Home > Data Source Settings. To display the Data Source Settings dialog box, do one of the following:
0 Comments
Leave a Reply. |