• Colin Doyle CFO

A quick tip for breaking links in Excel

By J. Carlton Collins, CPA

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 Datatab 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.

#smlbizcfo #biznews #entrepreneur #SmallBusiness #ShopLocal #MakeItHappen


(805) 373-3825

68 Long Ct #1b, Thousand Oaks, CA 91360, USA

©2018 by Doyle Group, The Small Business CFO. Proudly created with