Microsoft Excel Mac Page Break Not Working Page Greyed Out

 
-->

Note

After putting Excel in safe mode one thing did happen. Under the page layout tab everything was active except orientation. But, when I clicked on margins or tried to reduce the size to something other than 100% or clicked on any of the other features they greyed out automatically and everything became useless once again.

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.

  • Can't execute code in break mode.; 2 minutes to read; In this article. You enter break mode when you suspend execution of code. This error has the.
  • Sep 17, 2017  A way you can make your page breaks visible on Excel for Mac. Microsoft Excel 2016 Tutorial. Work It Daily Recommended for you.

Microsoft Excel Mac Page Break Not Working Page Greyed Out On Iphone

Summary

Microsoft Excel 2000 and later versions of Excel may not automatically fit the worksheet to the page as earlier versions of Excel did.

This issue occurs when you click Page Setup on the File menu, click to select the Fit to check box on the Page tab, and then type the number of pages wide that you want the worksheet to fit. For example, you type 1.

More information

In earlier versions of Excel, when you click to select the Fit to check box and then specify a setting in either the page(s) wide by or the tall boxes, Excel would clear the manual page breaks both vertically and horizontally to automatically make the worksheet fit the page wide by the page tall.

However, in Excel 2000 and in later versions of Excel, the Fit to option does not automatically clear all the manual page breaks in a worksheet. Excel clears the manual page breaks for only the width or height that you specify. For example:

  • When you specify a page width setting in thepage(s) wide by box, Excel clears all the manual vertical page breaks in the worksheet.
  • When you specify a page height in the tallbox, Excel clears all the manual horizontal page breaks in the worksheet.
  • When you do not specify either a width or height by clearing both the page(s) wide by box and thetall box, Excel retains both the vertical and horizontal manual page breaks in the worksheet.

This is a design change in Excel 2000 and in later versions of Excel. This change gives you more flexibility when you fit a worksheet to a page.

-->

You can set up the Business Central deployment to support an Excel add-in that enables users in the Business Central client to work with data from list pages in Excel. Users can get fresh data from Business Central into Excel and push updated data from Excel to Business Central.

Microsoft Excel Mac Page Break Not Working Page Greyed Outlook

Without this add-in, users can open a list page in Excel from the Open in Excel action on the page, which does not allow them to push changed data back to Business Central. When this add-in is set up, the Open in Excel action is replaced by the Edit in Excel action.

Note

This feature is only available for the Web client.

Note

This Excel add-in is different than the Microsoft Excel Add-in that can be installed together with the Dynamics NAV Client connected to Business Central client by using the Business Central Setup.

Prerequisites

Your deployment must meet the following prerequisites:

  • Azure Active Directory (Azure AD) used to authenticate users.

    The Business Central Server instance, clients, and users must be configured for Azure Active Directory (Azure AD) authentication.

    For more information, see Authenticating Users with Azure Active Directory.

  • OData enabled and uses Secure Sockets Layer (SSL) for authentication.

    For more information, see Using Security Certificates with Business Central On-Premises.

  • Business Central Web Server installed and configured to use SSL (https).

    For more information, see Install Business Central and Configure SSL to Secure the Connection to Web Client.

  • If your deployment is multitenant, Business Central Web client must accept host names for tenants.

    For more information, see Configure the Web Server to Accept Host Names for Tenants.

  • Business Central client computers have a supported version of Excel.

    For more information, see System Requirements.

Expose the Business Central application Web API in Azure AD

When Business Central is configured for Azure AD authentication, the Business Central application is registered as an application in an Azure AD. Before the Excel Add-in can be configured, you must configure the Business Central application in Azure AD to expose its Web API.

For information about how to do this, see Quickstart: Configure an application to expose web APIs.

Register and configure an Azure AD Application for the Excel Add-in in Microsoft Azure

When Azure AD authentication was set up for your Business Central deployment, an Azure AD tenant was created in Microsoft Azure, and an application for Business Central was registered in the tenant. The Excel add-in requires that you add (register) a separate Azure AD application in the Azure AD tenant.

  1. Register an Azure AD application for the Excel add-in.

    You add the Azure AD application by using the Azure portal. For guidelines, see Register your application with your Azure Active Directory tenant.

    When you add an application to an Azure AD tenant, you must specify the following information:

    SettingDescription
    NameThe name of your application as it will display to your users, such as Excel Add-in for Business Central.
    Supported account typesSpecifies which accounts that you would like your application to support. For purposes of this article, select Accounts in this organizational directory only.
    Redirect URISpecifies the type of application that you are registering and the redirect URI (or reply URL) for your application. Select the type to Web, and in the redirect URL box, enter URL for signing in to the Business Central Web client, for example https://localhost:443/BC150/SignIn.
    The URI has the format https://<domain or computer name>/<webserver-instance>/SignIn, such as https://cronusinternationltd.onmicrosoft.com/BC150/SignIn or https://MyBcWebServer/BC150/Signin. Important The portion of the reply URL after the domain name (in this case BC150/SignIn) is case-sensitive, so make sure that the web server instance name matches the case of the web server instance name as it is defined on IIS for your Business Central Web Server installation.

    When completed, the Overview displays in the portal for the new Excel Add-in application.

  1. Grant the Excel add-in application permission to access the Business Central application Web API.

    You must give the Azure AD application for the Excel add-in delegated permission to access the Business Central application Web API in Azure AD (which you exposed earlier in this article). This allows users of the Excel add-in to access the OData web services to read and write data.

    1. From the application's Overview, select API Permissions.
    2. Select the Add a permission
    3. On the APIs my organization uses, select the Business Central application.
    4. Select Delegated permsission.
    5. Select the permission from the list, and then select Add Permission.

    For information, see Quickstart: Configure a client application to access web APIs.

  2. Configure OAuth2 authentication in the Excel add-in.

    The Excel add-in requires OAuth2 implicit grant flow to be enabled on the Excel Add-in application. You configure this in the manifest file for the Excel Add-in application. From the application's Overview, select Manifest, and then set 'oauth2AllowIdTokenImplicitFlow' and 'oauth2AllowImplicitFlow' to true:

  3. In the manifest, add the following URL entry to the 'replyUrlsWithType'::

    Remember to add a comma before or after this enter, depending on where you add it in the list.

  4. Copy the Application (Client) ID that is assigned to Excel add-in application.

    You can get this from the Overview page for the application. You'll need this to configure the Business Central Server instance.

This completes the work you have to do in the Azure portal. The final configuration is to add the Excel add-in to the Business Central Server instances.

Configure the Business Central Server Instances

You must add the Excel add-in to the Business Central Server instances in your deployment. You can use either the Business Central Server Administration tool or Set-NAVServerConfiguration cmdlet in the Business Central Administration Shell.

  1. In the Business Central Server Administration tool, in the Azure Active Directory section, set the Excel add-in AAD client ID field to the application (client) ID for the Excel add-in application that you copied from the Azure portal.

    If you use the Set-NAVServerConfiguration cmdlet, set the ExcelAddInAzureActiveDirectoryClientId key.

  2. In the Client Services section, set the Web Client Base URL field to the base URL of the Business Central Web client.

    This is the root portion of all URLs that are used to access pages in the web client. This must have the format https://[hostname:port]/[instance], such as https://MyBCWebServer/BC or https://cronusinternationltd.onmicrosoft.com/BC150.

    If using the Set-NAVServerConfiguration cmdlet, set the PublicWebBaseUrl key.

  3. In the OData Services section, set the OData Base URL field to the public URL for accessing OData services.

    The URL must have the following format https://<hostname>:<port>/<instance>/ODataV4/, such as https://localhost:7048/BC150/ODataV4/.

    With the Set-NAVServerConfiguration cmdlet, set the PublicODataBaseUrlkey.

    Instead of trying to fix the existing hiccup, we would be effectively starting over with the update.1. Word Press and hold the power button to turn it back on.3. Press Command + R immediately to enter recovery mode.4. Press and hold the power button to turn off the Mac.2.

    2020-3-19  I have tried to download Mac Office 2016 and even just Excel 2016, but both need Mac OS X 10.10. I am stuck between Mac Office 2011 and Mac Office 2016 because of Mac OS X 10.9.5. Does anyone have any advice as to how I can get Word (and more importantly Excel) back on my MacBook Pro with OS X 10.9.5? Microsoft office 2011 for mac 10 9 5 free download - Apple Safari, Windows 10, Microsoft Office 2011, and many more programs. Microsoft word for mac 10.9 5 1.

Use the Excel Add-In

Your users can now use the Excel add-in. When a list page shows the Edit in Excel action, then users can open lists, such as the Customers page, in Excel and work with the data there. They can use the add-in to update data in Business Central, and they can get fresh data from the database.

See Also

Microsoft Excel Mac Page Break Not Working Page Greyed Out

Microsoft Excel Mac Page Break Not Working Page Greyed Out Word

Configuring Business Central Server
Authenticating Users with Azure Active Directory