External Data Connections in Excel 2016

RyanKJM

New Member
Joined
Jun 15, 2022
Messages
2
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
I'm using Excel Professional Plus 2016 to connect to an external SQL Server connection.

First, I pull the data into the Excel sheet and now see the data that exists based on my query criteria. [Shown as columns A,B,C]

After that, I'm adding new manual columns that do not exist in the external database. In these columns, I am making manual notes in cells with the goal to have them stay aligned with the data that exists in the same row from the external database. [Shown as column E]

However, when I refresh the data and there are new rows, or if there are rows deleted, it throws off the alignment of the data I manually entered.
[I.e. from image -- I want Jason to always match C1, not D1 after a new row of data is added in]


I've tried each of the three buttons under 'External Data Properties' (Insert cells for new data, delete unused cells; Insert entire rows for new data, clear unused cells; Overwrite existing cells with new data, clear unused cells) and none of them seem to accomplish this.

Could anyone please provide feedback and help with this?

Thanks!
 

Attachments

  • 211417-capture.png
    211417-capture.png
    25.1 KB · Views: 30

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,223,893
Messages
6,175,249
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top