A Look into Workbook Designer and the Different Workbooks
A Look into Workbook Designer and the Different Workbooks
The Workbook Designer interface will be covered in more detail in a later section. However, this section will briefly cover Workbook Designer to understand the different workbooks and different levels of products/subassemblies. The image below shows all the available workbooks that can be tied to a product.
The workbooks are set up as follows:
Formulas can reference defined names and ranges from other workbooks. A variable from another workbook will be preceded by the workbook name (i.e., G!, W!, L!, S!, etc.).
Formula reading and writing will be covered in another section. If you would like to download the Workbook or Spreadsheet Hierarchy a link is available below.
Workbook communication isn’t entirely universal. There are levels to the workbooks that are required to eliminate cyclical calculations. The image below illustrates the different levels and communication.
Related Articles
Understanding the Workbook Designer Interface
Workbook Designer InterfaceWorkbook Designer contains more tools than the Edit Design Data interface. However, some of the advanced features of Edit Design Data are not available when working through Workbook Designer. The automatic formatting of ...Overview of Workbook Designer
The purpose of this article is to provide an overview of the Workbook Designer feature. How to Access the Workbook Designer The most commonly used method for accessing Workbook Designer is through the Edit Design Data feature, which can be accessed ...Overview: Passing Prompt Information Between Workbooks (Subassembly)
We have added the ability to pass custom information from the L! workbook (local prompts) to the S! workbook (subassemblies). Without that ability, the number of prompts is greater, and the complexity of formulas increases. When the formula ...Introduction to the Global Workbook
The Global Workbook can be accessed through the Workbook Designer interface and is labeled as the “G” workbook. All Global Variable information in the correct workbook location is visible and available to edit in the Global Variable user interface ...Overview & Tutorials: Face Frame Images 3 (Customizing in the Spreadsheet)
This is the third article in the series giving an overview of how to configure the custom face frame images in the default Microvellum shipping libraries of build 046.2 and higher. The first articles in the series discussed how to use the default ...
Recent Articles
Toolbox Release Notes | Build 25.1.0129.641
The following release notes apply to Toolbox build 25.1.0129.641. SMA Fixes A wide variety of issues with the Solid Model Analyzer have been resolved. Multiple modifications to existing interfaces or settings have been made to improve precision and ...Microvellum Foundation Library Release Notes | Build 25.0124
The following release notes apply to Microvellum Foundation Library build 25.0124. Additions Added Century Components Waste Bins, Vanity Organizers, and Base Cabinet Organizers. 11”, 14”, 17” Signature Series Bottom Mount 34qt & 50qt. 4”, 5”, 6”, 9”, ...SQL Server Backups
This article will list out the various types of backups you can create for databases hosted on an SQL Server, explore methods for creating backups manually and automatically, as well as list software/services that may assist you with backing up your ...Toolbox Release Notes | Build 25.1.0114.641
The following release notes apply to Toolbox build 25.1.0114.641. UI Fixes Several issues were reported and discovered within the OEM 2025 user interface. The following issues have been resolved: Fig. 1: Excess commands on the tool strip being ...Toolbox Release Notes | Build 25.1.102.641
The following release notes apply to Toolbox build 25.1.102.641 Toolbox OEM 2025 Work smarter, and faster with Toolbox 2025 (OEM). With an OEM Subscription, you’ll gain access to the latest toolsets and innovative features of Toolbox 2025. ...