stop update link messages

  • Thread starter Thread starter Kathy
  • Start date Start date
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!
 
Hi
one way:
- copy the cells containing these links
- use 'Edit - Paste Special - Values' to replace these formulas with their
values
 
Back
Top