Using Morefunc - Indirect.Ext when Offline
 

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?

Using Morefunc - Indirect.Ext when Offline
 

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



wrote in message
oups.com...
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?

Using Morefunc - Indirect.Ext when Offline
 

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

Tools|Morefunc|Include Morefunc in the Workbook

Peo Sjoblom wrote:
Make a copy of the workbook and paste all formulas as values and send that
copy

Using Morefunc - Indirect.Ext when Offline
 

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.

Using Morefunc - Indirect.Ext when Offline
 

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


Peo


"Aladin Akyurek" wrote in message
...
Or include morefunc in the workbook you distribute by means of:

Tools|Morefunc|Include Morefunc in the Workbook

Peo Sjoblom wrote:
Make a copy of the workbook and paste all formulas as values and send
that copy

Using Morefunc - Indirect.Ext when Offline
 

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message oups.com...
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.

Using Morefunc - Indirect.Ext when Offline
 

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