Converting a linked cells in a non-linked cells

**pittopitto** · 05-06-2007, 05:27 AM

Hello everybody!

To make my work much easier, I have linked the cells where I am working to cells of another table in another file. In that way I could quickly update the table when the linked table is changed.

However, I need to send the table to my supervisor. How can I de-link the table but keeping the updated values?

Many Thanks

Pitto

**oldchippy** · 05-06-2007, 08:03 AM

Can't you make a copy of the file (call it Supervisor), then select the table with the links, copy > paste special > values. Then send that to your supervisor, therefore retaining both of your original copies?

**pittopitto** · 05-06-2007, 09:04 AM

Oh yes! I must have been very stupid!!!! Why didn't I think about that before?? Maybe the thesis I am writing is destroying my remaining grey cells...

Thank you! :D

Pitto