I have a worksheet called Report which recieves its data from 3 spreadsheets,
as part of an email process I am saving the worksheet as a workbook and then
emailing to some users. THe problem is that when I save the active worksheet
it is keeping all the links associated with the sheet. What I want it to do
is copy the values and the formatting but not the links, is there any way to
do this

Thanks