How to retain cell values infile when reference file doesnt exist

Question

QUESTION: Hi Hope your insight can help me out and whoever else reads this. Thank you!

SITUATION: I've got anfile A which referencesfile G.

CHALLENGE: Because management only want me to email file A, how can I make it "independent" (and still hold it's values) after referencing from file G?

(I ask this because normally if file G isn't around file A in the same place - file A will spit a dummy, giving ERROR in cells where it references file G)

Hope that kinda makes sense.

Appreciate your help Ken and anybody else's.

Alex

ANSWER: Alex I think you need to convert the cells linked to file G to values prior to e-mailing. There are a lot of ways to do that; the best will depend on how many cells and the layout. Good luck, ---------- FOLLOW-UP ----------

QUESTION: Thanks for your pleasantly surprisingly quick reply So how do we convert the cells (linked to file G) to values?

As your time is most appreciated and if this takes too long to answer, please let me know what the "search term" is and some possible URLs or online resources and I can research it myself.

Thanks Ken, Alex

Answer

Alex

The easiest way to convert linked cells to values is to break the links. You would have to do that to a copy of the file before you send it as an attachment to your e-mail.

To break the links (in Excel 2007) look under the data tab, then connections. Workbooks with links to other workbooks will have the option to "edit links". That will allow you to break all the links to a particular workbook; which I believe will accomplish what you want.