I have a spreadsheet emailed to me on a fairly regular basis. I need to
change the layout of this and have written another sheet which points to the
relevant cells and inserts the data into my sheet. This is fine until I open
the sheet again, when I'm prompted to renew the links.

Can I somehow read the data from the emailed spreadshhet once, then break
the link so that th new sheet is standalone?

You may want to live without updating the links--especially if you send it back
and they expect the links to still work.

But if you can break the links by finding them and then converting to values
(copy|Paste special|Values).

In fact, xl2002 has an option under Edit|Links to help do this.

Or you can use Bill Manville's addin to help find the pesky ones.

Findlink.zip from
http://www.BMSLtd.co.uk/mvp

Ian Coates wrote:

I have a spreadsheet emailed to me on a fairly regular basis. I need to
change the layout of this and have written another sheet which points to the
relevant cells and inserts the data into my sheet. This is fine until I open
the sheet again, when I'm prompted to renew the links.

Can I somehow read the data from the emailed spreadshhet once, then break
the link so that th new sheet is standalone?

--

Dave Peterson