Hi all,

I'm putting together a spreadsheet that is using the INDIRECT function to link to a number of other spreadsheets. The problem with this is that the link only works when the other spreadsheets are open.

What I'd like to do is, once I've put together my report, to have a macro that removes formulas, but keeps the values - hence, others can read it without having to have the 15+ supporting spreadsheets open.

Any ideas?

TIA,

SamuelT