I often copy extracts from spreadsheets into workbooks and then copy / paste values to make the files smaller to email but also to prevent the "Do you want to update links.." question (which just causes unneccessary confusion).
But charts stay linked. Any way of converting them into a picture or something in excel? I can do it by copying into word instead but then I lose my headers.
Ruth Ballinger
