What's Up East Coast Column

Read all about it!

You got the lowdown in the column, now get the breakdown. (A very special THANK YOU to Diane Pullen from WUEC for making this column possible!)

ADVERTISE in the popular WUEC magazine and post your events for free! This full colour booklet has been around for over 5 years and several thousands of hard copies are printed and distributed bi-monthly in the Eastern Cape area.
Contact me TODAY to get your listing up. It costs less than you think!

        23 Oct 2017, 1:56 pm

        Break those stubborn links! (Issue 71) by Tiamari

        Sometimes Excel is worse than a bad salesman. A bad salesman will try to sell you something that you do not want or need. Excel, however, will force you into buying it!

        The good news is: There is almost always a “cooling off clause” in the contract.

        The bad news is: You might not even realize that you have bought something.

        While I was working on a book account solution for a client, I noticed that my computer seemed to get very slow whenever I was using Excel. It was as if I was working on very large documents. My workbooks took a long time to open and save, and I experienced a lot of unexplained hanging. After some investigation I realized that several of my worksheets linked to references in entirely different workbooks!

        THE ISSUE

        When you copy the formulas from one workbook into other workbooks, Excel assumes that you want these formulas linked to the original source document. Merely pasting the formulas into the destination workbook results in the source workbook's file name in each cell reference. Should you then delete or move the source document, your formulas will return an error. The cross-linking also negatively affects your computer’s performance.

        If you have identical tabs, columns and rows in the destination workbook, you might not even notice that the formulas are linked to another workbook. A pop-message message that prompts you to update links is usually a clear indication that you have external links.

        THE SOLUTION

        You need to break (or edit) the Excel links after copying.Here’s how to do it:

        Copy the data:

        1. Open the destination workbook

        2. In the source workbook, right click on the worksheet tab and select Move or Copy...

        3. In the To Book window, select the name of the destination workbook, and select the place where you want to insert the worksheet

        4. Make sure that the Create a copy option is ticked

        5. Click OK, which copies the worksheet to the destination workbook

        6. Close the source workbook

        Now break the links:

        1. On the Data tab, in the Connections Group, select Edit Links

        2. Click on Change Source, then browse for the destination file (the same document that you are working on) and click OK

        Editing the links to point to the destination file instead of the source file effectively breaks the links to any external documents.

        NEED HELP?

        Please feel free to book a session with me. I do software training on most of the popular Software packages. Send an email to email@tiamari.com or WhatsApp me on 061-341-9072.

            Showing all records: