Before sending spreadsheets outside your organization, "sanitize" them with Macabacus. Apply the sanitization tools described below to protect proprietary or personal information, check workbook integrity, and tidy up formatting/appearance. These tools can be accessed from the
Macabacus > Prepare to Share menu. Use the Prepare to Share dialog to perform several of these operations at once, on either a copy of the active workbook (recommended), or the original workbook. Macabacus will remember your last used Prepare to Share settings.
Use this option if you want to share data, but not the underlying methodology used to arrive at the numbers.
While proper font coloring is important to understanding how a model works, it looks cleaner to use black fonts when such understanding is not critical to the recipient. You should select this option if you are replacing formulas with values.
While cell comments can provide clarity to assumptions and methodologies used in a model, they may contain sensitive information or exchanges between colleagues that are not suitable for external distribution.
This tool replaces all defined names in formulas with their appropriate cell references, then deletes the name from the workbook.
Hidden worksheets may contain sensitive information or works-in-progress not suitable for external distribution. Be sure that removing hidden worksheets does not result in #REF! errors in your model.
Hide hidden worksheets so that they cannot be unhidden other than programmatically. This does not prevent viewing hidden worksheets, but does make it more difficult to view them. When performing this operation from the Prepare to Share dialog and "Remove hidden worksheets" is checked, hidden worksheets will be deleted, rather than buried.
Hidden rows and columns may contain sensitive information or works-in-progress not suitable for external distribution. Be sure that removing hidden rows and columns does not result in #REF! errors in your model.
Removes all charts from the workbook.
Removes all watches from the workbook.
Checks the entire workbook for formula errors, such as #REF!, #VALUE!, and #DIV/0! It is generally recommended that you check this option when preparing a workbook for distribution. This check is performed after removing hidden workbooks and hidden rows/columns to catch any errors resulting from these removals.
Remove all print area settings.
Hides gridlines on each worksheet in the workbook.
Zoom all worksheets in the workbook to 100%.
Returns the cursor and scroll to cell A1 on each worksheet in the workbook.
Extra spaces sometimes appear in imported data and can prevent you from sorting or otherwise processing data. They can also result in unsightly data/text misalignment that requires correction before publishing. This tool trims leading, trailing, and excess (e.g., double) spaces from cells. Note that only cells containing values, not formulas, will be trimmed.
Additionally, this tool removes worksheet names from formulas where not required. For example, a formula on Sheet1 that reads =Sheet1!B3 will be changed to =B3, since the self-referenced sheet name in the formula is unnecessary.
Break all hyperlinks in the workbook.
Select this option to have Macabacus attach the workbook modified using Prepare to Share tools to a new Outlook email. Outlook must be open in order to use this feature. If you choose to modify a copy of the active workbook, rather than the active workbook itself, and select this email option, Macabacus will close and discard the duplicate workbook (although it will remain attached to the new email).
Use Macabacus to generate PDFs of print areas in your workbooks. Macabacus' PDF functionality offers a few advantages over Excel's native PDF functionality:
Macabacus > Send button to PDF print areas from selected sheets or an entire workbook and attach the PDF to a new Outlook email. You can optionally choose to compress (zip) the attachment and select other options.
Macabacus > File > PDF to Folder button to generate a PDF of print areas from selected sheets and save the PDF to the active workbook's folder.
This documentation refers to Macabacus version 8.14.5. Some features and descriptions of these features may not
apply to older versions of Macabacus. Update your Macabacus software to take advantage of the latest features.