How to embed INDIRECT.EXT into workbook Excel 2007

D

DVAL

Please.
I need to pull data from another closed excel file!

Thank you for reading this especially if you are able to help me out on
this.
 
D

Don Guillett Excel MVP

Please.
I need to pull data from another closed excel file!

Thank you for reading this especially if you are able to help me out on
this.

INDIRECT does NOT work with closed workbooks. Use linking formulas or
a macro to open>get data>close
 
R

Ron Rosenfeld

Please.
I need to pull data from another closed excel file!

Thank you for reading this especially if you are able to help me out on
this.

You probably can't do that. The last posted note I've seen regarding
this is in HELP for the latest version:

"Warning : for the moment (october 2007), the tool described in this
page doesn't work with Excel 2007, because of a bug in a callback
function. Hopefully, it will be fixed by a service pack. Don't use it
if you want to share workbooks using Morefunc with people who work
with this Excel version."

And, in my installation, the "Include Morefunc" tool does not even
show up.
 
G

Gord Dibben

Place the add-in in a LAN storage folder where all recipients will have access
to the function as you have on your PC.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top