external table

  1. X

    Reference to table in different workbook is inconsistent?

    So... basicly what the title says. I have a formula which lets me filter values from a huge table as a database. the formula is as follows: =LET(Advanced, IFS(F2<>"",SEARCH(F2,'Verbrauchsmaterialien Datenbank (work in...
  2. L

    Create Arrays from external workbook and add worksheet table data to the arrays

    I have a workbook that will be my main program. From this workbook I need to do the following in VBA. 1) Reference external workbook (hardcoded location). 2) Create arrays based on the sheet names in this external workbook 3) Populate each array with the table data in each worksheet once the...
  3. P

    Error when mail-merging from spreadsheet with chart

    Hi, all I have a spreadsheet that I use to populate a Word template using a mail merge. I've recently modified the spreadsheet to chart certain information, and the chart is on its own sheet, but when running the Word mail merge using the new spreadsheet as a data source, I get the error...

This Week's Hot Topics

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
Top