Using Morefunc - Indirect.Ext when Offline

[John.Forr]

I have a spreadsheet that uses Morefunc to update values from about 30
different spreadsheets on my computer. I need to email this
spreadsheet to someone who will not have access to these individual
files. I've already got the function set to volatile=false, but when
this other user opens up the file, everything is blank. Is there a way
to retain the last value if the file can't be found to update?

 

[Peo Sjoblom]

Make a copy of the workbook and paste all formulas as values and send that
copy

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Aladin Akyurek]

Or include morefunc in the workbook you distribute by means of:

Tools|Morefunc|Include Morefunc in the Workbook

 

[John.Forr]

I've included morefunc in the workbook, but the problem is that this
user cannot access the files that indirect.ext is linking to.

Copy/pasting values would work, but isn't really the optimal solution
since its not 100% automated.

 

[Peo Sjoblom]

I also read it as if the linked workbooks were not available as well?


Peo

 

[Ron de Bruin]

Copy/pasting values would work, but isn't really the optimal solution

since its not 100% automated.

You can try this add-in
http://www.rondebruin.nl/mail/add-in.htm

 

[John.Forr]

That's correct, the linked workbooks will not be available.