indirect.ext

  1. A

    Morefunc Indirect.ext Pull Alternative - Faster and More Reliable

    I am currently searching for an alternative to 'MoreFunc' to pull data in from other CLOSED worksheets. Morefunc is very slow and often crashes and needs re-instating. I was wondering if anyone could help! The master document references multiple sub-documents to draw the data in. The...
  2. R

    Replacement for INDIRECT.EXT?

    For many years now, I have been using INDIRECT.EXT through MoreFunc to pull information from an external documents. I have just upgraded to Office 2016 (from 2007) and have discovered that my documents no longer work. So I need a replacement. One of the big uses was in our budget. The salary...
  3. V

    INDIRECT.EXT function can't get over then 400 rows

    :confused: It seems that INDIRECT.EXT function (when the sheet is closed) can't get over then 400 rows; what can I do to solve this problem?
  4. I

    INDIRECT.ext Problems

    Hey guys, I'm trying to use INDIRECT.EXT to reference a cell in another workbook. However, I keep getting a #REF! error. In cell L2: '\\IN-ACCOUNTING1\Accounting\EOP_workpapers\Books\AAL\2012\04\[CN3008R_CGS.csv]CN3008R_CGS'!F9 L2 is a concatenation as follows...
  5. J

    Simple link to external xls file

    a1: 210.xls a2: 211.xls a3: 250.xls .... an: 335.xls In my master xls file, I want to link a cell from each of the above files listed in column A. If I type (say to cell B1) =[210.xls]sheet1!$B$6 I can get the value of cell "B6" of "sheet1" of file "210.xls" Now my question: Is there a way to...
    • jogeor
    • Thread
    • external link harlan grove indirect() indirect.ext pull()
    • Replies: 8
    • Forum: Excel Questions

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