System Requirements

Experience the power of F9.

Do I have Excel 32-bit or 64-bit?

  • In Excel choose File
  • Select either Account or Help
  • Under Product Information click About
Do I have Excel 32-bit or 64-bit?

Do I have Excel Click-to-Run?

  • From Control Panel choose Programs and Features
  • Select Microsoft Office and click Change
  • In the opened window you will see different options depending on whether it is a full or Click-to-run version

Click-to-Run Installation:

Click-to-Run Installation

Full Installation:

Full Installation

F9 Report Writer / Viewer

F9 Report Manager

Operating Systems

Desktop / Workstation

  • Windows 8.1 and 10 (32 and 64-bit) (Win 10 S is not supported) - (Note: For F9 products using PSQL on Windows 10 and Windows Server 2016, only PSQL V12 is supported.)
  • Windows 7 and Vista (32 and 64-bit)

Server

  • Windows Server 2016 (Note: For F9 products using PSQL on Windows 10 and Windows Server 2016, only PSQL V12 is supported.)
  • Windows Server 2012 and 2012 R2 (Note: Server Core installations with WoW64 uninstalled are not supported)
  • Windows Server 2008 (32 and 64-bit) and 2008 R2 (64-bit)

Not supported

  • Windows 10 S
  • Windows XP and earlier and Windows Server 2003
  • Windows RT
  • F9 Professional LDI Editor supported on Windows XP

Microsoft Office Excel Versions

F9 V5 and F9 Viewer require .NET Programmability support in Excel. Only fully installed versions of Office are supported. Click-to-Run versions that are only partially downloaded or installed locally are NOT supported. Office running on the Web is not supported.

Click-To-Run Office is a technology where Office is not installed on a PC until Click-To-Run is invoked. This invocation could be started by clicking the “Install Office” button while signed into the web-based versions of Office 365 or 2016. Alternatively it might be invoked by your IT department as a “deployment”. Traditionally, software is only available to run after it is downloaded and installed but Click-To-Run allows you to start using Excel (or other Office apps) by downloading and giving you access to very basic functionality right away while the remaining part of the Office installation program is downloaded. Once the remaining Office components are downloaded/deployed, (which could take an hour or more depending on your internet/network connection), they are installed in the background while you are actively using Excel, to enable all Excel’s functionality.

During this transition time where Office is being downloaded and installed on a PC, this PC does not have a complete installation of Excel. The F9 add-in cannot be installed/added to Excel properly until the download AND install are completed (all Excel add-ins are not compatible until the full install of Excel is available).

So, F9 is technically not compatible UNTIL Click-To-Run Office fully completes the download AND installation.

Bitness of Excel

Recent Office and Excel comes in two architectures called "bitnesses" - either 32-bit or 64-bit. Versions of Excel after 1994 and before Excel 2010 were 32-bit only. The F9 add-in must match the bitness of the Excel it is attaching to. There are different F9 installs for 32 and 64-bit Excel.

Supported Versions

  • Office 365 + Office ProPlus or Professional Plus 2013/2016 with Excel installed on-premise (full installation) (32 or 64bit)
  • Excel 2016 (32/64-bit) (Desktop Application)
  • Excel 2013 (32/64-bit) (Desktop Application)
  • Excel 2010 (64-bit)
  • Excel 2010 (32-bit)
  • Excel 2007

Not supported

  • Office Online
  • Incompletely downloaded/installed versions of Click-To-Run Office ProPlus

F9 Publishing to Viewer Restrictions

  • External links that are parameters of an F9 formula are not supported when published to F9 Viewer
  • External links that are parameters of an Excel formula (but not within an F9 formula) are supported when published with the Enabled Parameters option only

Microsoft .NET Framework Requirements

  • .NET Framework 4.5 or later is required. On some Windows operating systems, .NET Framework must be enabled as a feature within the OS

Remote Desktop Services/Terminal Server and Citrix

  • Windows Server 2016
  • Windows Server 2012 (64-bit) and 2012 R2 (64-bit)
  • Windows Server 2008 (32 and 64-bit) and 2008 R2 (64-bit)

Databases Supported (Dependent on accounting system)

  • Microsoft SQL Server 2000/2005/2008/2008 R2/2012/2014/2016, SQL Express (Note: SQL Server Native Client ODBC driver is not supported after SQL Server 2012)
  • Providex 5.14.0.0
  • FoxPro 9
  • Oracle 10g, 11g
  • Actian PSQL™ (formerly Pervasive) up to version 12 (client 32-bit). For F9 Report Manager or Scheduler, the "Allocate Resources at Startup" setting in the Pervasive Control Center should be enabled. Also for F9 products using PSQL on Windows 10 and Windows Server 2016, only PSQL V12 is supported.

Hardware

Disk space

Individual F9 products typically take up less than 30MB of space. An F9 Professional installation with Datapump and Actian PSQL combined may approach 300MB.

Memory

This can vary widely depending on the size of the data in your ERP and the functionality you use in F9. The base F9 V5 add-in along with it's dependent components takes approximately 60MB of RAM. For F9 Professional, the base Pervasive database engine requires approximately 140MB of RAM. Large amounts of data may add to this value significantly. It is important to understand that the size of the content of your workbooks can be quite substantial in memory and Excel's memory usage can easily dwarf the amount of memory used for F9 itself. These are per-user amounts as well so shared server resources need to be examined carefully to maximize performance.

F9 Report Manager Requirements

  • Workstation OS: Windows Vista through Windows 10
  • Server OS: Windows Server 2008 through Windows Server 2016
  • Windows Task Scheduler v2
  • .NET Framework 4.5
  • Excel 2007 SP2 or higher (32 or 64bit versions)
  • F9 Version 5 and/or F9 Viewer installed and configured
  • For ERPs using Actian SQL (Pervasive) databases (this includes F9 Professional implementations), the "Allocate Resources at Startup" setting in the Pervasive Control Center should be enabled

F9 Connect For SharePoint 2010/2013

Server Machine

  • SharePoint Enterprise 2010/2013
  • Recommended: Office Web App (enhanced-browser based editing for Excel)
  • Standard and Enterprise Client Access Licenses (CAL) to access Excel Services
  • IT Resource responsible for SharePoint 2010/2013 Site Administration

Notes:

If F9 Connect for Professional:

  • Actian PSQL™ (formerly Pervasive) Client 10 or 11 SharePoint Server
  • Actian PSQL™ (formerly Pervasive) Vx Server 11 on the database server

Client Machine

  • Microsoft Excel 2007, 2010 or 2013
  • F9 Version 5

Notes:

If F9v5 for Professional:

  • Actian PSQL™ (formerly Pervasive) Client 10 or 11 on F9 Workstations, installed as an Application (not as a Service)

F9 Connect For SharePoint 2007

Server Machine

  • Microsoft Windows SharePoint Services 3.0
  • Microsoft Office SharePoint Server (MOSS) 2007 Enterprise (32-bit)
  • Client Access License (CAL) with Excel Services configured
  • IT Resource responsible for SharePoint 2007 Site Administration

MOSS 2007 requirement:

If MS SQL Server Accounting Database:

  • Windows SharePoint Services 3.0
  • .NET Framework 3.0 or 3.5
  • ASP.NET 2.0
  • SQL Server 2000 minimum, SQL Server 2005 recommended

Notes:

If MS SQL Server Accounting Database:

  • Expertise and configuration of Kerberos Authentication required

If F9 Connect for Professional:

  • Actian PSQL™ (formerly Pervasive) Client 10 or 11 SharePoint Server
  • Actian PSQL™ (formerly Pervasive) Vx Server 11 on the database server

Client Machine

  • Microsoft Excel 2007 or Excel 2010
  • F9 Version 5

Notes:

If F9v5 for Professional:

  • Actian PSQL™ (formerly Pervasive) Client 10, 11 or 12 on F9 Workstations, installed as an Application (not as a Service)

Databases Supported (Dependent on accounting system)

  • Microsoft SQL Server 2005/2008/2012, SQL Express
  • Actian PSQL™ (formerly Pervasive) 10, 11, or 12

Have a specific question? We’re here to help!

Contact Us