A quick tip for breaking links in Excel

By J. Carlton Collins, CPA

(Editor's note: This tip comes from JofA reader Rick Stone, CPA, controller at The Walt Disney Family Museum in San Francisco. Thank you, Rick, for bringing this tip to our attention.)

Let's say you have a workbook that contains numerous data links and formulas, but when you send this workbook to others, they get error messages because your links don't follow the same link path on their computers. However, copying and pasting the data to a new workbook as values doesn't work either because this process removes all formulas, which makes the worksheet less usable. Is there a decent way to solve this problem?

A practical approach that may work for you is to save a copy of your workbook and then highlight your entire worksheet and from the Data tab select Edit Links, Break Link. This action will remove all links from your workbook but leave your formulas intact so your recipients can still edit the data to produce "what-if" scenarios for deeper analysis.

techqa-4

About the author

J. Carlton Collins, CPA, (carlton@asaresearch.com) is a technology consultant, a conference presenter, and a JofA contributing editor.

Submit a question

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

SPONSORED QUIZ

How well do you know small business?

There are over 30 million small businesses in the U.S., and many of them are optimistic in their outlook. Are you familiar with the obstacles and opportunities they are facing? Test your small business acumen with this quiz sponsored by Chase Ink®.

SPONSORED REPORT

Tax reform complicates year-end tax planning

Get your clients ready for tax season with these year-end tax planning strategies, which address how to make the most of recent tax law changes, such as the new deduction for qualified business income, the higher standard deduction, and the cap on the deductibility of state and local taxes.