external data connections

  1. B

    Can't Find External Links to Remove

    I wanted to add some intelligence to a coworker's spreadsheet, so I copied the workbook, normalized his data into tables, built a model, added a measure and then showed him the results. All good. Since he had further updated the original workbook I thought I would copy my work back into his. I...
  2. S

    Retrieving single cell of data from large external database without increasing file size

    Hi All, I have a large database with 460.478 unique "Postal Codes". I also have a workbook in which I want to fill in one of the "Postal Codes" and as a result get the "Municipality" and "Water Authority" for that specific Postal Code. Right now i have a simple but working solution which is...
  3. M

    Import CSV file and problems with breaking external data link

    Using Excel 2007. Having a few problems. I need to make a workbook that will automatically import a log file and present a few different charts to choose from. A user form will present options to view charts, print, email and save as pdf. I'm using FileDialog(msoFileDialogFilePicker) and...
  4. C

    Conversion to 365 killed External Data Connections

    My company converted to Office 365 today. I use a lot of external data connections in my Excel files. After the conversion none of these work. Most are connecting to a server vs a mapped drive. Is there a way to get these to work without redoing everything? Thanks! Crystal
  5. E

    Can I manage external connections from Access in Excel?

    Hi, I have one table in an Access DB and I use data from there for a table in Excel. Unfortunately the data includes some sensitive information (columns) which I want to leave out in that specific Excel file (I use the DB table for other purposes where I do need the sensitive data). Is there...

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