Infor Lawson Excel Add in Download Install

What the Infor Lawson Excel Add-in Actually Does

If your organization runs Infor Lawson for HR, payroll, or financials, you've probably run into the frustration of exporting data to Excel the slow way — running reports, downloading files, reformatting columns, and repeating the whole cycle whenever anything changes. The Infor Lawson Excel Add-in exists specifically to cut out that friction. It connects your Excel environment directly to Lawson, letting you pull, view, and in some configurations write back data without leaving the spreadsheet. For HR analysts and finance teams who live in Excel, this changes the daily workflow considerably.

This guide covers what the add-in does, how to download and install it, what to watch for during setup, and common issues that come up after installation.

Before You Download: Prerequisites and Access

The Lawson Excel Add-in isn't a standalone tool you grab from a public website. It's distributed through your organization's Infor Lawson environment, which means you need a few things in place before installation makes sense.

First, you need an active Lawson user account with the appropriate security roles. The add-in connects to Lawson using your credentials, and whatever access restrictions apply to your account in Lawson will apply through the add-in as well. If you can't run a particular report in Lawson itself, you won't be able to pull that data through Excel either.

Second, you need the right version of Excel. The add-in has typically supported 32-bit versions of Excel even on 64-bit Windows installations — this catches people off guard, because most modern Office installations default to 64-bit. Check your Excel version (File → Account → About Excel) before downloading. Installing the wrong add-in version is one of the most common reasons for immediate post-install failures.

Third, you'll need the Lawson server URL and portal address from your IT or system administrator. The add-in connects to a specific Lawson instance, and you'll need that address during configuration. HR operations depend heavily on system access being properly configured and maintained, and the Excel add-in is one of those tools that requires upfront coordination with IT rather than a self-service download.

Where to Find the Download

The Infor Lawson Excel Add-in is typically available through your organization's Lawson portal. The standard path is to log into the Lawson portal, navigate to the Tools or Resources section (the exact label varies by implementation), and look for the Excel Add-in or Smart Office download options.

Some organizations host the installer on an internal network share or send it via IT request. If you can't find it in the portal, contact your Lawson system administrator — they'll either point you to the right location or distribute the installer directly. Downloading from unofficial or external sources isn't advisable; the add-in needs to match your specific Lawson version.

The file you're looking for is typically an .exe or .msi installer. File names vary by version but often include "LawsonExcelAddIn," "SmartOffice," or "IOSClient" in the name. Infor has moved some Excel integration functionality into Infor OS and Infor Smart Office over the years, so the naming in your environment depends on which version of the platform your organization is running.

Installing the Add-in: Step by Step

Once you have the installer, close Excel completely before running it. Installing while Excel is open is a reliable way to get a partial installation that doesn't behave correctly.

Run the installer as administrator. Right-click the file and select "Run as administrator" — this ensures the installer can write to the necessary registry keys and program directories. If you install without admin rights, the add-in may appear to install but fail to load in Excel.

Follow the installation wizard prompts. In most versions, you'll be asked to accept the license agreement, confirm the installation directory, and optionally enter the Lawson server URL during setup. If the wizard doesn't ask for the server URL, you'll configure that later within Excel.

After installation completes, open Excel. You should see a new tab in the ribbon — typically labeled "Lawson" or "Infor." If the tab doesn't appear, go to File → Options → Add-ins, check the COM Add-ins list, and enable the Lawson add-in if it's listed but not active. Clear configuration steps matter in any technical implementation — if the add-in is installed but not enabled, it simply won't show up, which can feel like an installation failure when it's actually just a settings issue.

Configuring the Connection to Lawson

With the add-in installed and the Lawson tab visible in Excel, you'll need to configure the connection to your Lawson server. Click on the Lawson tab and look for a Settings or Configuration option. You'll enter the Lawson portal URL here — the same URL you use to access Lawson through a web browser.

Save the settings, then use the Login or Connect option in the ribbon to authenticate. You'll be prompted for your Lawson username and password. Once connected, the add-in allows you to access Lawson data directly from Excel — running queries, pulling records, and in some implementations submitting transactions.

If your organization uses single sign-on (SSO) or multi-factor authentication, the login flow may route through a browser window rather than a simple dialog box. This is expected behavior in environments using Infor OS-based authentication. Enterprise systems increasingly use centralized identity management, and Lawson's authentication follows whatever your organization has configured at the platform level.

Common Installation Problems and How to Fix Them

The most frequent issue after installation is the add-in tab not appearing in Excel. The causes, in order of likelihood: Excel is 64-bit and the add-in is the 32-bit version (or vice versa); the add-in was installed without administrator rights; or the add-in is installed but disabled in Excel's COM Add-in settings. Check these three things in order before assuming the installation itself failed.

Connection errors after a successful login prompt usually point to network or firewall issues. The add-in needs to reach the Lawson server on specific ports — your IT team can confirm which ones and verify that they're open on your machine. VPN requirements are another common factor; if Lawson is hosted on-premises or in a private cloud, you may need to be connected to the corporate VPN for the add-in to establish its connection.

If the add-in connects but returns no data or produces errors when running queries, the problem is usually permissions-related. Your Lawson security roles determine what data is accessible, and those roles apply equally through the Excel interface. Contact your Lawson administrator to verify that your account has the roles needed for the specific data you're trying to access. Access control and data security matter in every enterprise tool — the add-in respects Lawson's security model, so role gaps show up as data access errors rather than connection failures.

Performance Considerations

The Lawson Excel Add-in pulls live data from the Lawson server, which means query performance depends on server load, network speed, and the size of the dataset you're pulling. Large queries — thousands of records across multiple fields — can take a while. If you find yourself consistently waiting on queries, consider whether you're pulling more data than you actually need. Filtering at the query level (asking Lawson for a subset of records) is significantly faster than pulling everything and filtering in Excel afterward.

It's also worth being aware of session timeouts. Like the Lawson web portal, the Excel add-in connection will time out after a period of inactivity. If you return to an Excel workbook and find the connection broken, you'll need to log in again. This isn't an error — it's standard session management behavior. HR professionals already managing high administrative loads don't need avoidable tool friction — knowing about session timeouts in advance prevents the confusion of unexplained connection drops mid-workflow.

When the Add-in Isn't the Right Tool

The Excel Add-in works well for pulling current data and doing analysis in a familiar spreadsheet environment. It's less suited for bulk data exports, scheduled automated pulls, or anything requiring a formal audit trail. For those use cases, Lawson's built-in reporting tools, Data Export (DX) functionality, or integrations with BI platforms are typically more appropriate.

If your organization has moved to Infor CloudSuite or is in the process of migrating from Lawson, check with your IT team about which Excel integration tools are supported in the target environment. Infor OS and CloudSuite have their own Excel integration capabilities that may differ from the traditional Lawson add-in. Understanding which tools apply to which workflows saves time that would otherwise be spent troubleshooting the wrong solution.

Getting the Most Out of It

Once the add-in is working, invest a little time learning its query builder. The ability to define exactly which fields you want, apply filters before pulling data, and save query templates for repeated use is where the real productivity gains come from. An analyst who builds a solid library of saved queries can refresh data that would have taken an hour of manual exports in a matter of seconds.

Coordinate with colleagues who use the same tool — shared query templates and a common understanding of field definitions reduce redundant work and inconsistencies across reports. The add-in is most valuable when it's used consistently across a team rather than as a one-off workaround by individual users.

Comments

Post a Comment

Popular Posts

Why Workday New Hire Onboarding Breaks Down for Frontline Employees and What Actually Fixes It

Image
The Onboarding Gap Nobody Talks About Workday's onboarding module is well-designed for its intended audience: office-based, desk workers with reliable computer access, personal email addresses, and the digital literacy to navigate a web-based portal. For this population, Workday onboarding works well — it automates tasks, routes approvals, collects documents, and creates a reasonably smooth first-week experience. But most organizations using Workday have a substantial population of frontline workers: warehouse employees, retail staff, manufacturing workers, healthcare aides, food service workers, drivers. For this population, the standard Workday onboarding experience frequently fails in ways that are predictable, documented, and — crucially — fixable. Understanding why it breaks down and what actually works is increasingly urgent as labor market competition for frontline talent intensifies. How Standard Workday Onboarding Is Designed Workday's new hire onboarding (delivered th...
Read more

AI Agents in HR: How Autonomous Workflows Are Transforming Onboarding, Offboarding, and Compliance

Image
CloudApper AI automates routine HR workflows including onboarding, offboarding, and compliance monitoring without replacing your existing HRIS. Most HR teams have used automation for years: rules-based workflows that trigger an email when a form is submitted, or integrations that push data between systems when a field changes. AI agents are a fundamentally different category. They don't execute rules — they reason. An AI agent can receive an ambiguous input ("this new hire's visa status has changed"), determine what it means in context, decide what actions are required across multiple systems, execute those actions, and report back with a summary — without a human scripting each step. The distinction matters practically. Rule-based automation breaks when inputs vary. AI agents handle variation by design. For HR — where every employee situation is slightly different, documentation requirements shift with jurisdiction, and processes depend on role, location, depa...
Read more

ERP Solution Guide: How to Choose the Best ERP for Your Business

What Is an ERP System and Why Does It Matter? An enterprise resource planning (ERP) system is software that integrates the core functions of a business — finance, inventory, procurement, human resources, manufacturing, and customer management — into a single, connected platform. Instead of data living in separate spreadsheets or standalone applications that don't talk to each other, an ERP creates one source of truth for the entire organization. For growing companies, the question is usually not whether they need an ERP but when and which one. Getting this decision right has long-term consequences. A poorly chosen ERP creates more problems than it solves — forcing teams to work around the system, creating data integrity issues, and consuming IT resources in an endless cycle of customization and maintenance. A well-chosen ERP, on the other hand, becomes the operational backbone that lets a company scale without proportionally growing its administrative overhead. Understandin...
Read more

Apple Targeting to Increase Average Selling Prices (ASPs) Instead of iPhone Volume

The shift Apple made that changed how the smartphone industry counts success For most of its history as a smartphone maker, Apple played a numbers game it wasn't going to win. Samsung, Huawei, and a dozen Chinese manufacturers could always out-ship Cupertino on raw unit volume. The market share charts told one story — and it wasn't Apple's story. What changed, gradually and then all at once, was the metric Apple decided mattered. Instead of chasing the most iPhones sold, Apple started engineering for the highest average selling price (ASP) per iPhone sold. That shift explains more about Apple's financial performance over the past decade than any product launch, any carrier deal, or any tariff negotiation. Understanding why Apple made this pivot — and how it executes the strategy — is worth the attention of anyone who follows business strategy, consumer technology, or premium product markets. The ASP playbook Apple runs is precise, deliberate, and widely misread as s...
Read more

How to Select a Business Process Outsourcing Vendor

Image
What Is Business Process Outsourcing and Why Does Vendor Selection Matter? Business process outsourcing (BPO) involves delegating specific business functions — payroll, customer support, IT services, HR administration, data entry, and more — to a third-party provider. Done right, BPO reduces overhead, gives you access to specialized expertise, and lets your team focus on core competencies. But selecting the wrong vendor can cost you far more than doing it in-house. Poor vendor choices lead to data breaches, compliance failures, missed SLAs, and damaged customer relationships. This guide walks you through the practical criteria for selecting a BPO vendor that actually fits your organization. Step 1: Define Exactly What You're Outsourcing Before you evaluate a single vendor, get precise about scope. Document: Which processes are being outsourced (not just "customer service" but "inbound tier-1 support, Mon–Fri, 8am–8pm EST") Volume expectations — cur...
Read more

Does Workday Track Employee Location During Check-In and Check-Out? A Clear Guide for Admins

If you're an HR admin or IT manager trying to understand how Workday handles location data during employee check-ins and check-outs, you're not alone. The question comes up constantly — especially as organizations expand their use of Workday's mobile time-tracking features and start wondering exactly what data is being collected, how it's stored, and what employees can and can't see about their own location history. The short answer: yes, Workday can track employee location during check-in and check-out, but only when certain features are explicitly enabled and configured. It doesn't happen automatically by default. Here's what admins actually need to know. How Workday location tracking works Workday's time tracking module includes GPS-based location capture as an optional feature tied to mobile clock-in events. When an employee clocks in or out using the Workday mobile app, the application can record the device's GPS coordinates at the moment ...
Read more

Managing Mixed Payroll Frequencies Across Countries: A Practical Approach for Global Teams

Image
The Hidden Complexity of Global Payroll Running payroll for a team in one country is manageable. Running payroll for teams across five, ten, or twenty countries simultaneously — each with different pay frequencies, different regulatory requirements, different currencies, and different definitions of what constitutes payable time — is one of the most technically demanding operations in global HR. The mistakes are costly, the regulatory exposure is real, and the employee trust implications of getting it wrong are significant. Mixed payroll frequencies are at the center of this complexity. In the US, weekly and bi-weekly payroll are common. In Germany, monthly is legally standard for most employees. In the UK, weekly payroll is common for hourly workers while monthly dominates for salaried staff. In Canada, bi-weekly and semi-monthly coexist across provinces. Managing these different cycles within a unified HR and payroll system, while maintaining accurate accounting, correct benefit dedu...
Read more

10 Benefits of HRMS Software for Your Business

Image
What HRMS Software Actually Does for a Business Human Resource Management System (HRMS) software consolidates the core functions of people management — hiring, onboarding, payroll, time tracking, performance management, benefits administration, compliance, and reporting — into a single platform. That's the straightforward definition. But the business case for HRMS adoption goes considerably deeper than administrative convenience, and understanding the actual benefits helps organizations make better implementation decisions and extract more value from the platforms they've already bought. Here are 10 meaningful, concrete benefits that well-implemented HRMS software delivers. 1. Dramatic Reduction in Administrative Labor Costs Manual HR administration — data entry, paper filing, chasing managers for approvals, reconciling payroll spreadsheets — consumes enormous amounts of HR staff time in organizations that haven't automated. Studies consistently show that HR professionals i...
Read more

The Evolving Role of HR Leaders in Performance Management to Meet Modern Workplace Needs

Image
The Annual Review Is Dying. What Replaces It Matters Enormously. The annual performance review — the cornerstone of performance management for decades — is in unmistakable decline. Adobe eliminated annual reviews in 2012. Accenture dropped them in 2015. General Electric, the company that popularized forced ranking distributions, abandoned the practice. Deloitte surveyed its own leaders and found that 58% believed their performance management approach drove neither employee engagement nor high performance. Goldman Sachs and Microsoft made high-profile changes. The direction of travel is clear. But dismantling the annual review is easy. Building something better requires genuine redesign — and that redesign increasingly falls to HR leaders who must shift from administrators of evaluation processes to architects of continuous performance systems. Understanding how this role is evolving, what the research supports, and what the pitfalls are matters for every HR professional navigating this...
Read more

10 Things You Should Consider Before Choosing Paylocity HR Payroll Solution

Image
Why Choosing the Right HR and Payroll Platform Matters Selecting an HR and payroll solution is one of the most consequential technology decisions a growing organization makes. The wrong platform creates compliance risk, payroll errors, frustrated employees, and costly migrations down the road. Paylocity is a well-regarded option in the mid-market HR technology space — but like any platform, it isn't right for every organization. Before signing a contract or beginning an implementation, there are ten critical factors every HR leader should evaluate when considering Paylocity. 1. Company Size and Scalability Paylocity is built for small to mid-sized businesses — typically organizations with 10 to 1,000 employees. If your organization is in hypergrowth mode or anticipates scaling beyond that range, evaluate whether Paylocity's architecture will grow with you without requiring a costly platform switch in two or three years. Ask specifically how Paylocity handles multi-entity s...
Read more