A quick tip for breaking links in Excel

(itor’s note: This tip comes from JofA reader Rick Stone, CPA, ler at The Walt Disney Fly Museum in San Francisco. Thank you, Rick, for bringing this tip to our atttion.)

Let’s say you have a workbook that contains numerous ta links and formulas, but wh you sd this workbook to others, they get error messs because your links n’t follow the same link path on their comers. However, copying and pasting the ta to a new workbook as values esn’t work either because this process removes all formulas, which makes the worksheet less usable. Is there a dect way to solve this problem?

A practical approach that may work for you is to save a copy of your workbook and th highlight your tire worksheet and from the ta tab select it Links, Break Link. This action will remove all links from your workbook but your formulas intact so your recipits can still it the ta to produce “whatif” scarios for er analysis.

About the author

J. Carlton Collins, CPA, (carlton@asaresearch.com) is a technology ultant, a conferce prester, and a JofA contributing itor.

Submit a question

you have technology questions for this column? Or, after reading an answer, you have a better solution? Sd them to jofatech@aicpa.org. We regret being unable to individually answer all submitt questions.


8 thoughts on “A quick tip for breaking links in Excel”

Leave a Reply