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!
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.
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.
Please feel free to book a session with me. I do software training on most of the popular Software packages. Send an email to firstname.lastname@example.org or WhatsApp me on 061-341-9072.
Showing all records: