stop update link messages

K

Kathy

I have a workbook I received (via email) from someone we buy from, I take
that workbook and edit it to be able to send individual sheets to my
customers. Problem is, original workbook creator has links from other
workbooks on his machine When I open the workbook it asks me do I want to
update the links. Well I couldn't if I wanted to because I don't have the
workbooks its asking about. How do I get rid of these warnings. I want to
email my individual worksheets to my customers but I don't want them to see
this Update message when it doesn't pertain to them (it's very frustrating).

Any help suggestions would be great.

Thanks in Advance!
 
F

Frank Kabel

Hi
one way:
- copy the cells containing these links
- use 'Edit - Paste Special - Values' to replace these formulas with their
values
 
Top