Configure Microsoft Excel 2016

If you are not already logged in, login to the Liquent InSight Rendering Server as local administrator.

  1. Launch Microsoft Excel.
  2. In Microsoft Excel, click File > Options.
  3. Click General.
  4. Under User Interface options, set the ScreenTip style to Don't Show ScreenTips option.
  5. Under Start up options, clear the following options:
    • Tell me if Microsoft Excel isn't the default program for viewing and editing spreadsheets
    • Show the Start screen when this application starts 
  6. Click Formulas and then under Error Checking, clear the Enable background error checking option.
  7. Click Save and then under Save workbooks, clear the Save AutoRecover information every option.
  8. Click Advanced.
  9. Under Cut, copy and paste:
    1. Clear the following options:
      • Show Paste Options button when content is pasted
      • Show Insert Options buttons
    2. Select the following option:
      • Cut, copy and sort inserted objects with their parent cells
  10. Under Display, clear the Show function ScreenTips option.
  11. Under General, clear the following options:
    • Ask to update automatic links
    • Scale content for A4 or 8.5 x 11" paper sizes
  12. Click Trust Center.
    1. Under Microsoft Excel Trust Center, click Trust Center Settings.
    2. Click Privacy Options and then clear all options.
  13. Click File Block Settings and clear all Open and Save boxes.
  14. Select Message Bar, and then select Never show information about blocked content option.
  15. Select Protected View, and then clear all options.
  16. Select Macro Settings.
    1. Select Enable all macros option.
    2. Select Trust access to the VBA project object model option.
  17. Select ActiveX Settings.
    1. Select Enable all controls without restrictions and without prompting option.
    2. Clear Safe mode option.
  18. To close the Excel Options dialog box, click OK twice.
  19. Close Microsoft Excel.