14Fathoms products are built within Microsoft Excel so it is important to understand how to best use Microsoft Excel.  Too many sheets or heavy formatting in any Excel workbook can make the Excel file seem sluggish or freeze. A few things to try to make an Excel file run faster:

    1. Disable hardware graphics acceleration in Excel. This should make substantial improvement:
      1. Open Excel
      2. Click “File”
      3. Click “Options”
      4. Click “Advanced”
      5. Scroll down to the “Display” section
      6. Tick “Disable hardware graphics acceleration”disablehardwareaccelerations
      7. Click OK to save
    2. Move the file to your computer’s desktop. Running from a network drive can cause A LOT of latency. Once you are finished working on the Excel file, move it back to the network drive. NOTE: Do not use a file over VPN. Always move the file to a local drive then move it back to your network drive using VPN. The products are not supported over VPN connections.
    3. Use the file in “Offline” mode. Click the “About” box in the Scope Sheet toolbar > Use Offline Mode:offlineMode
    4. Close all unnecessary programs and files. Like any software, Excel is competing for finite resources (processing power and RAM) on your computer. Closing extraneous programs frees resources for Excel to use. Specifically:
      • Close unnecessary tabs in all web browsers.
      • Do not stream music or videos while working within Excel.
      • Check that all the programs in your Windows system tray are necessary. If they do not need to be running, right-click to close them. If you are not sure what the programs are for, you should contact your IT department.  Any programs that you close should restart when you reboot your computer.
    5. Make sure your 14Fathoms’ calculation mode is set to Auto in the 14Fathoms’ About box (not in the built-in Excel calculation settings). See this FAQ for details.
    6. Turn off conditional formatting: Click Home in the toolbar > Conditional Formatting Options > Select your formatting options > click Save.
    7. Change your default printer to “Microsoft XPS Writer” or a PDF printer. This sounds odd, but Windows and print drivers in Excel are known to slow things down.
    8. Restart your computer and only open the Excel files you need to work with at the moment.

    If the above doesn’t help, please contact us, and we can provide more information to improve your use of Microsoft Excel.