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?