Punchblog430

-->

1. Office Table Interior Design
2. Office Table With Drawers

As a Microsoft 365 admin, you can choose to do the following tasks on the Office installation options page in the Microsoft 365 admin center:

• Manage which version of Office is installed, including

Office Table Interior Design

The 'Microsoft 365' tab gives you easy access to your most-recently-used Office cloud files (both SharePoint and OneDrive), your SharePoint sites, and the top Office Online apps. There are additional tabs that show Office documents that have been shared with you, and documents that might be of interest to you. Free download Office Tab - bring tabbed user interface to Office Brings tabbed browsing, reading, editing, and managing documents in Microsoft Office 2019. Become an Insider: be one of the first to explore new Microsoft 365 features for you and your business. Free download Office Tab - bring tabbed user interface to Office. Brings tabbed browsing, reading, editing, and managing documents in Microsoft Office 2019, 2016, 2013, 2010, 2007, 2003 and Office 365.

If you don't want users installing Office themselves, you can manually deploy Office to your users.

Tip

To get to Office installation options, sign in to the Microsoft 365 admin center with your admin account, and then go to Show all > Settings > Org settings > Services.

Choose how often to get feature updates for Office

You can choose how often you want your users to get feature updates for the Office apps installed on devices running Windows. For example, you can provide new features as soon as they're ready, or once a month (on the second Tuesday of the month), or twice a year (in January and July, on the second Tuesday).

We recommend Current Channel, because it provides your users with the newest Office features as soon as they are ready. If you need additional predictability of when these new Office features are released each month, we recommend Monthly Enterprise Channel. In those cases where you have select devices that require extensive testing before receiving new features, we recommend Semi-Annual Enterprise Channel.

For more information, see Overview of update channels for Microsoft 365 Apps.

After you select an update channel under Feature updates and choose Save, your choice of update channel will apply to both new and existing installations of Office in your organization. You can change your channel selection at any time.

For new installations, your update channel selection will apply to any new installations of Office that are initiated by your users at My account > Apps & devices.

For existing installations of Office, your selection will be applied to devices within 12 hours. Devices will automatically get the latest build from the selected update channel the next time they check for Office updates. Office will be updated directly from the Office Content Delivery Network (CDN) on the internet.

Keep in mind that moving to a different update channel can also change which features are available to your users. For more information about which features are available in each update channel, see Release notes for Microsoft 365 Apps releases.

Note

• Your choice under Feature updates won't apply if you're already using some other method to manage Office on devices in your organization. For example, if you’re using Office policy settings (with Group Policy or Office cloud policy service), Microsoft Endpoint Configuration Manager, Microsoft Intune, or the Office Deployment Tool (either the Channel or the UpdatePath attribute in the Updates element. You’ll need to use that method to change the update channel on those devices instead of using Office installation options.

• If you’re using the Office Deployment Tool in a different way (for example, specifying the Channel attribute in the Add element), and not any of the other methods mentioned in the previous bullet point, then your choice under Feature updates will apply to those devices.

• Your choice under Feature updates applies only to new, but not existing, installations if you have one of the following plans: Office 365 operated by 21Vianet, Office 365 Germany, Office 365 GCC, or Office 365 GCC High and DoD.

Manage which version of Office is installed

You can also, in certain situations, roll back devices in your organization to a previous version of Office or skip an upcoming version.

This capability is available to you on the Version management tab in the Microsoft 365 admin center, under Settings > Org settings > Services > Office installation options. The Version management tab is only shown if you have chosen Monthly Enterprise Channel for feature updates on the Installation options tab. You can only manage versions of Office that are installed on devices running Windows.

Note

• Your choices on the Version management tab won't apply if you're already using some other method to manage Office on devices in your organization. For example, if you’re using Office policy settings (with Group Policy or Office cloud policy service), Microsoft Endpoint Configuration Manager, or Microsoft Intune.

• If you’re using the Office Deployment Tool to manage Office on devices in your organization, but none of the other methods mentioned in the previous bullet point, then your choices on the Version management tab will apply to devices in your organization.

• The Version management tab isn't available if you have one of the following plans: Office 365 operated by 21Vianet, Office 365 Germany, Office 365 GCC, or Office 365 GCC High and DoD.

On the Version management tab, you can see your current version, your previous version, and your next scheduled version of Office for Monthly Enterprise Channel. Updates to Monthly Enterprise Channel are released on the second Tuesday of each month.

Roll back to a previous version

If you’re having a problem with the current version of Office, you can roll back devices in your organization to a previous version of Monthly Enterprise Channel.

If you decide to roll back to a previous version, devices in your organization will roll back to that previous version the next time Office checks for updates. Also, the information on the Version management tab will be updated to show that the previous version is now the current version for devices in your organization.

If you want to stay on that previous version beyond the next version update, you’ll also need to choose Skip this version. If you don’t, devices in your organization will be updated to the most recent version available starting on the second Tuesday of the month. That update will come directly from the Office Content Delivery Network (CDN) on the internet.

We don’t recommend staying on a version that is no longer supported and that is no longer receiving security updates.

Skip an upcoming version

If you want to stay on your current version of Office, you can skip the next scheduled version for Monthly Enterprise Channel. But, you can only skip one version at a time.

If you want to skip more than one upcoming version, you need to go to the Version management tab before the second Tuesday of the month and once again choose Skip this version. If you don’t choose Skip this version, devices in your organization will be updated to the most recent version available starting on the second Tuesday of the month. That update will come directly from the Office Content Delivery Network (CDN) on the internet.

If you skip a version, you won’t be able to roll back to that version at a later time. The information displayed on the Version management tab will always show you which version you can roll back to.

We don’t recommend staying on a version that is no longer supported and that is no longer receiving security updates.

Choose whether users can install Office on their own devices

As an admin, you can control which Office software your users can download and install from My account > Apps & devices. Whichever choices you make, they apply to all users in your organization.

If you choose to make some software unavailable to your users, they will see a message on their Apps & devices page instead of an Install button. For example, if you choose to make Office unavailable, users see this message:

Your admin has turned off Office installs. Contact your admin for more information about how to get Office in your organization.

Note

• Users have to be local administrators on their devices to install Office software. If users aren't local administrators, you'll have to install Office for them. For more information, see Manually deploy the Office apps.
• For users to be able to install Office, you need to assign them a license.
• By default, Office installs all the apps that are included in your version of Office on the user's device. If you want some users to get only certain apps, such as only Word and PowerPoint, you can use the Office Deployment Tool to deploy Office to your users with only those apps.

Manually deploy Office to your users

From the Manually deploy apps to users page, you can download the installation packages for Skype for Business or Office for Mac. For more information about deploying Office for Mac, see Deployment guide for Office for Mac.

Manually deploy the Office apps

If you don't want your users to install software themselves from My account > Apps & devices, there are several ways you can deploy Office to devices running Windows in your organization.

One way you can deploy Office to your users is by using the Office Deployment Tool, which you can download for free from the Microsoft Download Center. You can use the Office Deployment Tool on its own or with your existing software deployment tools and processes. For more information, see Overview of the Office Deployment Tool.

You can use the Office Deployment Tool to configure your deployments of Office, whether you’re installing Office directly from the Office Content Delivery Network (CDN) on the internet or from a shared folder on your network. As part of the installation, you can, for example, specify an update channel, include additional languages, or exclude certain applications from being installed, such as Access or Publisher.

If available to your organization, you can also use Microsoft Endpoint Configuration Manager or Microsoft Intune to deploy Office to your users. For more information, see Manage Microsoft 365 Apps with Configuration Manager and Add Microsoft 365 apps to Windows 10 devices using Microsoft Intune.

Manually deploy InfoPath 2013 and SharePoint Designer 2013

In addition to Office, you can download InfoPath 2013 and SharePoint Designer 2013 in order to deploy them to your users. You can download them from the Microsoft Download Center by using the following links:

• InfoPath 2013 (32-bit and 64-bit versions)

• SharePoint Designer 2013 (32-bit and 64-bit versions)

After you download the software, you can use your existing software deployment tools and processes to deploy InfoPath or SharePoint Designer to your users.

Note

If you want your users to install InfoPath 2013 or SharePoint Designer 2013 for themselves, there are links to the downloads on My account > Tools & add-ins.

Related articles

A contextual tab is a hidden tab control in the Office ribbon that is displayed in the tab row when a specified event occurs in the Office document. For example, the Table Design tab that appears on the Excel ribbon when a table is selected. You can include custom contextual tabs in your Office Add-in and specify when they are visible or hidden, by creating event handlers that change the visibility. (However, custom contextual tabs do not respond to focus changes.)

Note

This article assumes that you are familiar with the following documentation. Please review it if you haven't worked with Add-in Commands (custom menu items and ribbon buttons) recently.

Important

Custom contextual tabs are currently only supported on Excel and only on these platforms and builds:

• Excel on Windows (Microsoft 365 subscription only): Version 2102 (Build 13801.20294) or later.
• Excel on the web

Note

Custom contextual tabs work only on platforms that support the following requirement sets. For more about requirement sets and how to work with them, see Specify Office applications and API requirements.

You can use the runtime checks in your code to test whether the user's host and platform combination supports these requirement sets as described in Specify Office applications and API requirements. (The technique of specifying the requirement sets in the manifest, which is also described in that article, does not currently work for RibbonApi 1.2.) Alternatively, you can implement an alternate UI experience when custom contextual tabs are not supported.

Behavior of custom contextual tabs

The user experience for custom contextual tabs follows the pattern of built-in Office contextual tabs. The following are the basic principles for the placement custom contextual tabs:

• When a custom contextual tab is visible, it appears on the right end of the ribbon.
• If one or more built-in contextual tabs and one or more custom contextual tabs from add-ins are visible at the same time, the custom contextual tabs are always to the right of all of the built-in contextual tabs.
• If your add-in has more than one contextual tab and there are contexts in which more than one is visible, they appear in the order in which they are defined in your add-in. (The direction is the same direction as the Office language; that is, is left-to-right in left-to-right languages, but right-to-left in right-to-left languages.) See Define the groups and controls that appear on the tab for details about how you define them.
• If more than one add-in has a contextual tab that is visible in a specific context, then they appear in the order in which the add-ins were launched.
• Custom contextual tabs, unlike custom core tabs, are not added permanently to the Office application's ribbon. They are present only in Office documents on which your add-in is running.

Major steps for including a contextual tab in an add-in

The following are the major steps for including a custom contextual tab in an add-in:

1. Configure the add-in to use a shared runtime.
2. Define the tab and the groups and controls that appear on it.
3. Register the contextual tab with Office.
4. Specify the circumstances when the tab will be visible.

Configure the add-in to use a shared runtime

Adding custom contextual tabs requires your add-in to use the shared runtime. For more information, see Configure an add-in to use a shared runtime.

Define the groups and controls that appear on the tab

Unlike custom core tabs, which are defined with XML in the manifest, custom contextual tabs are defined at runtime with a JSON blob. Your code parses the blob into a JavaScript object, and then passes the object to the Office.ribbon.requestCreateControls method. Custom contextual tabs are only present in documents on which your add-in is currently running. This is different from custom core tabs which are added to the Office application ribbon when the add-in is installed and remain present when another document is opened. Also, the requestCreateControls method can be run only once in a session of your add-in. If it is called again, an error is thrown.

Note

The structure of the JSON blob's properties and subproperties (and the key names) is roughly parallel to the structure of the CustomTab element and its descendant elements in the manifest XML.

We'll construct an example of a contextual tabs JSON blob step-by-step. The full schema for the contextual tab JSON is at dynamic-ribbon.schema.json. If you are working in Visual Studio Code, you can use this file to get IntelliSense and to validate your JSON. For more information, see Editing JSON with Visual Studio Code - JSON schemas and settings.

1. Begin by creating a JSON string with two array properties named actions and tabs. The actions array is a specification of all the functions that can be executed by controls on the contextual tab. The tabs array defines one or more contextual tabs, up to a maximum of 20.

2. This simple example of a contextual tab will have only a single button and, thus, only a single action. Add the following as the only member of the actions array. About this markup, note:

   • The id and type properties are mandatory.
   • The value of type can be either 'ExecuteFunction' or 'ShowTaskpane'.
   • The functionName property is only used when the value of type is ExecuteFunction. It is the name of a function defined in the FunctionFile. For more information about the FunctionFile, see Basic concepts for Add-in Commands.
   • In a later step, you will map this action to a button on the contextual tab.

3. Add the following as the only member of the tabs array. About this markup, note:

   • The id property is required. Use a brief, descriptive ID that is unique among all contextual tabs in your add-in.
   • The label property is required. It is a user-friendly string to serve as the label of the contextual tab.
   • The groups property is required. It defines the groups of controls that will appear on the tab. It must have at least one member and no more than 20. (There are also limits on the number of controls that you can have on a custom contextual tab and that will also constrain how many groups that you have. See the next step for more information.)

   Note

   The tab object can also have an optional visible property that specifies whether the tab is visible immediately when the add-in starts up. Since contextual tabs are normally hidden until a user event triggers their visibility (such as the user selecting an entity of some type in the document), the visible property defaults to false when not present. In a later section, we show how to set the property to true in response to an event.

4. In the simple ongoing example, the contextual tab has only a single group. Add the following as the only member of the groups array. About this markup, note:

   • All the properties are required.
   • The id property must be unique among all the groups in the tab. Use a brief, descriptive ID.
   • The label is a user-friendly string to serve as the label of the group.
   • The icon property's value is an array of objects that specify the icons that the group will have on the ribbon depending on the size of the ribbon and the Office application window.
   • The controls property's value is an array of objects that specify the buttons and menus in the group. There must be at least one.

   Important

   The total number of controls on the whole tab can be no more than 20. For example, you could have 3 groups with 6 controls each, and a fourth group with 2 controls, but you cannot have 4 groups with 6 controls each.

5. Every group must have an icon of at least two sizes, 32x32 px and 80x80 px. Optionally, you can also have icons of sizes 16x16 px, 20x20 px, 24x24 px, 40x40 px, 48x48 px, and 64x64 px. Office decides which icon to use based on the size of the ribbon and Office application window. Add the following objects to the icon array. (If the window and ribbon sizes are large enough for at least one of the controls on the group to appear, then no group icon at all appears. For an example, watch the Styles group on the Word ribbon as you shrink and expand the Word window.) About this markup, note:

   • Both the properties are required.
   • The size property unit of measure is pixels. Icons are always square, so the number is both the height and the width.
   • The sourceLocation property specifies the full URL to the icon.

   Important

   Just as you typically must change the URLs in the add-in's manifest when you move from development to production (such as changing the domain from localhost to contoso.com), you must also change the URLs in your contextual tabs JSON.

6. In our simple ongoing example, the group has only a single button. Add the following object as the only member of the controls array. About this markup, note:

   • All the properties, except enabled, are required.
   • type specifies the type of control. The values can be 'Button', 'Menu', or 'MobileButton'.
   • id can be up to 125 characters.
   • actionId must be the ID of an action defined in the actions array. (See step 1 of this section.)
   • label is a user-friendly string to serve as the label of the button.
   • superTip represents a rich form of tool tip. Both the title and description properties are required.
   • icon specifies the icons for the button. The previous remarks about the group icon apply here too.
   • enabled (optional) specifies whether the button is enabled when the contextual tab appears starts up. The default if not present is true.

The following is the complete example of the JSON blob:

Register the contextual tab with Office with requestCreateControls

The contextual tab is registered with Office by calling the Office.ribbon.requestCreateControls method. This is typically done in either the function that is assigned to Office.initialize or with the Office.onReady method. For more about these methods and initializing the add-in, see Initialize your Office Add-in. You can, however, call the method anytime after initialization.

Important

The requestCreateControls method can be called only once in a given session of an add-in. An error is thrown if it is called again.

The following is an example. Note that the JSON string must be converted to a JavaScript object with the JSON.parse method before it can be passed to a JavaScript function.

Specify the contexts when the tab will be visible with requestUpdate

Typically, a custom contextual tab should appear when a user-initiated event changes the add-in context. Consider a scenario in which the tab should be visible when, and only when, a chart (on the default worksheet of an Excel workbook) is activated.

Begin by assigning handlers. This is commonly done in the Office.onReady method as in the following example which assigns handlers (created in a later step) to the onActivated and onDeactivated events of all the charts in the worksheet.

Next, define the handlers. The following is a simple example of a showDataTab, but see Handling the HostRestartNeeded error later in this article for a more robust version of the function. About this code, note:

• Office controls when it updates the state of the ribbon. The Office.ribbon.requestUpdate method queues a request to update. The method will resolve the Promise object as soon as it has queued the request, not when the ribbon actually updates.
• The parameter for the requestUpdate method is a RibbonUpdaterData object that (1) specifies the tab by its ID exactly as specified in the JSON and (2) specifies visibility of the tab.
• If you have more than one custom contextual tab that should be visible in the same context, you simply add additional tab objects to the tabs array.

The handler to hide the tab is nearly identical, except that it sets the visible property back to false.

The Office JavaScript library also provides several interfaces (types) to make it easier to construct theRibbonUpdateData object. The following is the showDataTab function in TypeScript and it makes use of these types.

Toggle tab visibility and the enabled status of a button at the same time

The requestUpdate method is also used to toggle the enabled or disabled status of a custom button on either a custom contextual tab or a custom core tab. For details about this, see Enable and Disable Add-in Commands. There may be scenarios in which you want to change both the visibility of a tab and the enabled status of a button at the same time. You can do this with a single call of requestUpdate. The following is an example in which a button on a core tab is enabled at the same time as a contextual tab is made visible.

In the following example, the button that is enabled is on the very same contextual tab that is being made visible.

Localizing the JSON blob

The JSON blob that is passed to requestCreateControls is not localized the same way that the manifest markup for custom core tabs is localized (which is described at Control localization from the manifest). Instead, the localization must occur at runtime using distinct JSON blobs for each locale. We suggest that you use a switch statement that tests the Office.context.displayLanguage property. The following is an example:

Then your code calls the function to get the localized blob that is passed to requestCreateControls, as in the following example:

Best practices for custom contextual tabs

Implement an alternate UI experience when custom contextual tabs are not supported

Some combinations of platform, Office application, and Office build don't support requestCreateControls. Your add-in should be designed to provide an alternate experience to users who are running the add-in on one of those combinations. The following sections describe two ways of providing a fallback experience.

Use noncontextual tabs or controls

There is a manifest element, OverriddenByRibbonApi, that is designed to create a fallback experience in an add-in that implements custom contextual tabs when the add-in is running on an application or platform that doesn't support custom contextual tabs.

The simplest strategy for using this element is that you define in the manifest one or more custom core tabs (that is, noncontextual custom tabs) that duplicate the ribbon customizations of the custom contextual tabs in your add-in. But you add <OverriddenByRibbonApi>true</OverriddenByRibbonApi> as the first child element of the CustomTab. The effect of doing so is the following:

• If the add-in runs on an application and platform that support custom contextual tabs, then the custom core tab won't appear on the ribbon. Instead, the custom contextual tab will be created when the add-in calls the requestCreateControls method.
• If the add-in runs on an application or platform that doesn't support requestCreateControls, then the custom core tab does appear on the ribbon.

The following is an example of this simple strategy.

This simple strategy uses a custom core tab that mirrors a custom contextual tab with it's child groups and controls, but you can use a more complex strategy. The <OverriddenByRibbonApi> element can also be added as (the first) child element to the Group and Control elements (both button type and menu type), and menu <Item> elements. This fact enables you to distribute the groups and controls that would otherwise appear on the contextual tab among various groups, buttons, and menus in various custom core tabs. The following is an example. Note that 'MyButton' will appear on the custom core tab only when custom contextual tabs are not supported. But the parent group and custom core tab will appear regardless of whether custom contextual tabs are supported.

For more examples, see OverriddenByRibbonApi.

When a parent tab, group, or menu is marked with <OverriddenByRibbonApi>true</OverriddenByRibbonApi>, then it isn't visible, and all of it's child markup is ignored, when custom contextual tabs aren't supported. So, it doesn't matter if any of those child elements have the <OverriddenByRibbonApi> element or what its value is. The implication of this is that if a menu item, control, or group must be visible in all contexts, then not only should it not be marked with <OverriddenByRibbonApi>true</OverriddenByRibbonApi>, but its ancestor menu, group, and tab must also not be marked this way.

Important

Don't mark all of the child elements of a tab, group, or menu with <OverriddenByRibbonApi>true</OverriddenByRibbonApi>. This is pointless if the parent element is marked with <OverriddenByRibbonApi>true</OverriddenByRibbonApi> for reasons given in the preceding paragraph. Moreover, if you leave out the <OverriddenByRibbonApi> on the parent (or set it to false), then the parent will appear regardless of whether custom contextual tabs are supported, but it will be empty when they are supported. So, if all the child elements shouldn't appear when custom contextual tabs are supported, mark the parent, and only the parent, with <OverriddenByRibbonApi>true</OverriddenByRibbonApi>.

Use APIs that show or hide a task pane in specified contexts

As an alternative to <OverriddenByRibbonApi>, your add-in can define a task pane with UI controls that duplicate the functionality of the controls on a custom contextual tab. Then use the Office.addin.showAsTaskpane and Office.addin.hide methods to show the task pane when, and only when, the contextual tab would have been shown if it was supported. For details on how to use these methods, see Show or hide the task pane of your Office Add-in.

Handle the HostRestartNeeded error

Office Table With Drawers

In some scenarios, Office is unable to update the ribbon and will return an error. For example, if the add-in is upgraded and the upgraded add-in has a different set of custom add-in commands, then the Office application must be closed and reopened. Until it is, the requestUpdate method will return the error HostRestartNeeded. Your code should handle this error. The following is an example of how. In this case, the reportError method displays the error to the user.