Question

To make changes to the existing data.​

Answer 1

Answer:

Make changes to an existing data source in Power Pivot

Excel for Microsoft 365 Excel 2021 Excel 2019 More...

After you create a connection to an external data source in a Data Model, you can use the Power Pivot add-in to change:

The connection information—including the file, feed, or database used as a source, its properties, or other provider-specific connection options.

Table and column mappings.

Remove references to columns that are no longer used.

The tables, views, or columns you get from the external data source. See Filter the data you import into Power Pivot.

Make changes to an existing data source in Power Pivot

Excel for Microsoft 365 Excel 2021 Excel 2019 More...

After you create a connection to an external data source in a Data Model, you can use the Power Pivot add-in to change:

The connection information—including the file, feed, or database used as a source, its properties, or other provider-specific connection options.

Table and column mappings.

Remove references to columns that are no longer used.

The tables, views, or columns you get from the external data source. See Filter the data you import into Power Pivot.

Explanation:

please mark me as brainliest

Answer 2

In the power pivot Window.Click home>connections>existing connection.2.is select the current database connection and click edit.3.is In the edit connection dialog box,click browse to locate another data base of the same type but with a different name or location..4 is Click save >close .