Macabacus and Microsoft (for the most part) no longer support Internet Explorer 10 and prior versions. Please consider upgrading your browser.
One of Macabacus' most popular features is the ability to link PowerPoint and Word to cell ranges and charts in Excel. When you export a range/chart to PowerPoint/Word, Macabacus links the pasted shape—a picture, table, chart, etc.—to the source range/chart. If you later modify the underlying Excel data, you can update the linked shape in PowerPoint/Word with the click of a button to reflect the new data.
Linking between Excel and PowerPoint/Word is possible with native Office functionality, but the limitations of this functionality render it practically useless. These limitations include:
Linking with Macabacus has a number of important advantages over native Office linking:
To understand how Macabacus links to cells, it is first important to understand range names (or "defined names," if you prefer). Range names refer to a cell or range of cells, and are normally managed using Excel's native Name Manager. They are commonly used in formulas like =SUM(FirstQuarterSales), where the name "FirstQuarterSales" refers to cells C5:F5, for example. Suppose we insert a row above row 5. Now, the name "FirstQuarterSales" refers to cells C6:F6. By using the range name "FirstQuarterSales," we can ignore the actual address of the cells to which the name refers, which can change as you insert/delete rows/columns or otherwise change the structure of your workbook.
When you export a range to PowerPoint or Word, Macabacus automatically links to the range by defining a unique, hidden name for the range in the source workbook. Hidden names are not visible in Excel's Name Manager, so you cannot view these names there, but you can view hidden names in Macabacus' Name Scrubber. Macabacus then stores the unique name within the destination PowerPoint presentation or Word document so that Macabacus knows where to find the linked cells when you want to work with links (e.g., update links, view the source) in those applications.
Since Macabacus links to a range name, which reliably refers to the source range object (unless the range was deleted altogether), rather than the source range's unreliable address, you can safely modify the structure of your source workbook without affecting link integrity. In addition, when you save your source workbook as a new version, all range names created by Macabacus for linking purposes carry over to the new version (as do all names), making it possible to relink previously linked objects in PowerPoint/Word to the new source workbook.
Now, what if we want to add a column to the right of the source range, so that our output in PowerPoint shows six columns instead of five? Since range names created by Macabacus for linking work like any other range name, this is simply an exercise in working with native Excel functionality—you simply insert the new column within the source range, rather than next to it.
If a workbook open in Excel has the same name as the workbook to which a shape or other object is originally linked, Macabacus linking operations (Update Link and View Source) look in that workbook first for the source range/chart. This workbook's file path may be different from the path to the workbook to which you originally linked, which is common when "saving up" your source workbooks (e.g., renaming from "Model v1.xlsx" to "Model v2.xlsx"), working with local versions of source workbooks shared using cloud storage services (e.g., Box), and in other scenarios.
If the source range/chart is found in an open workbook with the same name as the source workbook, Macabacus looks no further. However, if the source range/chart is not found in that workbook, Macabacus looks in all other open workbooks. If multiple open workbooks contain the source range/chart, Macabacus will use the most recently modified workbook. If Macabacus does not find the source range/chart in any open workbook, it will attempt to open the source workbook from its last known file path. Prior to opening the source workbook to update links, specifically, Macabacus checks the source file's folder for newer versions of the source file.
If the workbook in which the source range/chart is ultimately found does not have the same file path as the workbook to which you originally linked, Macabacus transparently re-links to the former workbook.
If you have multiple instances of your Office applications running, Macabacus (and add-ins, generally) cannot reliably determine which instance to reference. Therefore, when performing certain operations like updating links and viewing link sources, Macabacus requires that a single instance of each applicable Office app is running. You can check whether you have multiple instances running in Task Manager on the Details tab, and multiple instances are most common in Excel 2007 and 2010. This is rarely an issue in Excel 2013 and later, as Microsoft now consolidates Excel instances.
Select one or more linked shapes in PowerPoint or Word and click the Macabacus > Update Link button. Neither the source workbook nor Excel need to be open to update linked shapes; Macabacus will open them as required. If you have appended version numbers (generally recommended) or dates to your file names (e.g., "My_Model_v4.xlsx" or "Balance Sheet 2015-12-31.xlsx"), Macabacus automatically searches for file names with more recent version numbers and dates in the same folder as the current source workbook. If any potentially newer versions of the source workbook are found, Macabacus prompts you to relink to them when updating links. For Macabacus to find newer versions of source workbooks, version numbers and dates must appear at the end of the file name. If you use a date in your file name, the date must be separated from the rest of the file name by a space or underscore character.
Version control uses Microsoft technology that limits the fully qualified file name to less than 260 characters, and the directory name to less than 248 characters. Also, version control is not currently supported in SharePoint.
Select one or more linked shapes in PowerPoint or Word and click the Macabacus > Edit Link button. This opens the Edit Link dialog that allows you to change the source workbook, source range, source chart, or linked shape type. For example, you can use this dialog to relink a linked shape to a newer version of the source workbook, and change the linked shape from an embedded workbook to a picture. Links do not update automatically after editing them—you must initiate a link update separately.
Select one or more linked shapes in PowerPoint or Word and click the Macabacus > View Source button. Macabacus will navigate to the source range or chart. If the source workbook is not already open, Macabacus will open it.
Select one or more linked shapes in PowerPoint or Word and click the Macabacus > Break Link button. This removes the link between the shape and its underlying Excel data.
In PowerPoint and Word, you can manage multiple linked shapes with the Manage Links dialog, accessed by clicking the Macabacus > Manage button. With the Manage Links dialog you can perform the operations described above on multiple linked shapes at once. For example, you would use this dialog to relink all linked shapes in a presentation to a newer version of the source workbook.
The Source Range column in Link Wizard shows the address of the cell(s) to which an object in PowerPoint or Word is linked. Because Macabacus links to the range object itself, rather than the range address, this address is strictly for informational purposes and may be incorrect at times. Think of this address as a "last known" address.
When you move or rename folders containing presentations and documents with Macabacus links, those links may no longer point to the correct source files. To point links to the correct files after moving or renaming folders, use the Find/Replace tab in the Manage Links dialog. Specify the old text in source file paths you want to replace, and the new text you want to replace it with. You can perform this operation on all links within the active presentation or document, or all presentations and documents in a folder. You should spot check the results of your find/replace operation once it is complete.
To minimize the risk of inadvertent mislinking in a large number of files caused by an improper find/replace operation, you must be a Macabacus account administrator or a Windows administrator to perform a find/replace operation on all presentations or documents in a folder. This feature is not available in SharePoint computing environments.
When performing a find/replace operation on all presentations or documents in a folder, be as explicit as possible in your find/replace inputs—use longer strings—to minimize the risk of unintended replacement. Also, note that Macabacus does not check the validity of new paths to source files created by your find/replace operation.
This documentation refers to Macabacus version 8.5.4, and may differ from the PDF documentation
on your computer that installed with your version of Macabacus.