# Excel for facilities managers on Mac: PM schedules, work orders and costs in 2026

> Excel for facilities managers on Mac: build PM schedules, work-order logs and cost trackers, with the Mac limits and voice help from Lazur.

URL: https://www.lazur.app/for/facilities-managers/excel
Updated: 2026-11-07

Excel for Mac handles the core facilities jobs: PM schedules, asset registers, work-order logs and cost tracking. You can start with the Microsoft 365 app you already have, and you need no extra software. Mac builds have gaps, though, and those gaps change how you should set up each sheet. This page covers the setup, the Mac-specific limits, and where Lazur helps while you work.

## Quick answer

- Keep one Table per job: PM schedule, asset register, work-order log and cost tracker.
- Use EDATE for next-due dates and conditional formatting with TODAY so overdue tasks flag themselves.
- Power Pivot is not available on Excel for Mac, and Power Query cannot be authored in its editor on Mac.
- Ask Lazur where a control is, what a formula does, or to walk you through a fix while you keep your hands on the mouse.

## What facilities managers keep in Excel on a Mac

Most facilities teams do not start with a system. They start with a spreadsheet that someone built years ago and nobody wants to rebuild. On a Mac, that file usually covers planned maintenance, a list of assets, a log of work orders, and a running cost total. Each one is a different job, and each one breaks in a different way.

Free templates shape most of these files. Maintenance software vendors publish templates for PM schedules and work orders, and those templates set the columns you end up copying. Read the columns before you copy them. A template built for a large technician team may not fit one building with a contractor who sends invoices by email.

- PM schedule: every recurring task, its frequency, the last date it was done and the next date due.
- Asset register: each piece of equipment with an ID, location, make, model, install date and warranty end.
- Work-order log: each request, who raised it, who owns it, its status and when it closed.
- Cost tracker: invoices, budgets and spend by building, asset or vendor, usually pulled from a monthly export.

Keep these as separate tabs or separate files. Mixing them on one sheet makes filters and pivot tables unreliable. A filter that hides a work order can also hide the cost that belongs to it.

Why keep using spreadsheets when software exists? The 2023 CMM in-house facility management benchmarking survey gives one answer. Spreadsheets and paper checklists together were still the most popular tools, used by 73% of respondents. The same survey says 46% use quality audit or inspection software. Optisolve sponsored the survey, and the article does not state the sample size. Read it as a signal, not a census.

- **73%** of 2023 CMM survey respondents used spreadsheets and paper checklists, the most popular tools ([source](https://cmmonline.com/articles/2023-cmm-in-house-facility-management-benchmarking-survey-report))
- **46%** of the same survey's respondents said they use quality audit or inspection software ([source](https://cmmonline.com/articles/2023-cmm-in-house-facility-management-benchmarking-survey-report))
- **5 to 10 hours a week** of coordinator time for an Excel PM schedule, per one CMMS vendor's page, which cites no source ([source](https://oxmaint.com/industries/facility-management/building-preventive-maintenance-schedule-template))

## Set up a preventive maintenance schedule that holds up

A PM schedule works when every row is one task on one asset, and every due date comes from a formula. Start by making the data a Table. Select your data, press ⌘ T, and confirm that the header row is ticked. Tables grow when you add rows, so your formulas follow the new data without manual fill-down.

Use these columns as a starting point: Asset ID, Asset name, Location, Task, Frequency in months, Last done, Next due, Owner and Status. Store the frequency as a plain number of months. That keeps the next-due formula short and easy to read later.

In the Next due column, enter =IF(F2="","",EDATE(F2,E2)). Here F2 holds Last done and E2 holds Frequency in months. EDATE adds that many months to a date. If the target month is shorter, EDATE returns its last valid day, which is what you want for monthly and quarterly checks.

> **Name the table first:** Microsoft's October 2026 What's New post says naming a table at creation is now available in Excel for Windows and Excel for Mac. Pick a clear name such as tblPMSchedule before you add formulas. Structured references read more clearly than cell ranges.

Watch for blank Last done cells. Without the IF wrapper, a blank date can return a date far in the past. That looks like a task that has been overdue for years. The wrapper shows a blank next-due cell until the task has been done once, which is the honest answer.

## Flag overdue tasks with conditional formatting and TODAY

Overdue tasks should announce themselves. Select the Next due column, then go to Home > Conditional Formatting > New Rule. Choose Use a formula to determine which cells to format. Enter =AND($G2<>"",$G2<TODAY()) and pick a fill color. Excel applies the rule to every row in the selection.

![A facilities manager working in Excel on a Mac laptop at a desk](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/facilities-managers-excel/excel-for-facilities-managers-on-mac-1-fe5b67.jpg)

TODAY() recalculates when the file opens and when cells change. A file left open for days may show stale flags until something recalculates. If the colors look wrong, close the file and reopen it before you trust the list. A flag that looks correct but is stale is worse than no flag at all.

Excel will flag the row, but it will not send an alert. A flag only helps if someone opens the file. Set a fixed weekly review, and put that review in your calendar.

## Track work orders without losing track of who owns what

A work-order log is a list of events that people update. This is where Excel struggles most. The Status column needs a fixed list of choices, not free typing. Otherwise you get Open, open, OPEN and Opn in one column, and your filters miss half of them.

Use data validation for the Status column. Select the column, then go to Data > Data Validation > Data Validation. Under Allow, choose List. In Source, type Open, In progress, Waiting on parts, Closed, with commas between the options. People then pick a status from a dropdown instead of retyping it.

Know the limits before you promise a team a shared log. A CMMS vendor's template page says Excel work orders leave field staff unable to access or update them. It also says multiple editors create conflicting versions, and nobody is alerted when a task is assigned, overdue or completed. Those are a vendor's words, not a study, but they describe the gaps you will hit.

![A maintenance technician checking a printed checklist inside a building](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/facilities-managers-excel/excel-for-facilities-managers-on-mac-2-0445fe.jpg)

Store the file in OneDrive or SharePoint so people co-author it instead of emailing copies. Co-authoring solves the copy problem. It does not add alerts. You still need a routine, or one person who checks the log every morning.

## Lookups and cost tracking that stay accurate

Cost tracking usually means matching invoices to assets. A lookup function does that job. XLOOKUP is the newer choice in current Microsoft 365 builds, and VLOOKUP still works. Pick one function and use it the same way across the whole file, so a colleague can read it in a minute.

The most common error is #N/A. It usually means the lookup value does not match exactly. Stray spaces are the usual cause. A vendor code with a trailing space, such as HVAC-North, will not match HVAC-North in your register. For a full walkthrough of that error, see [Excel VLOOKUP #N/A error how to fix on Mac](https://www.lazur.app/for/developers/problems/excel-vlookup-na-error-fix-steps).

1. Select the column of vendor codes, then go to Home > Find & Select > Replace.
2. In Find what, type a single space. Leave Replace with empty, then choose Replace All.
3. Run TRIM on the codes in a helper column, then paste the values back over the original column.
4. Recount the matches. Any #N/A left is a code that does not exist in your asset register.

Microsoft's Copilot clean data skill checks for extra spaces, inconsistent text, inconsistent dates, duplicates and values stored as the wrong data type. Microsoft says it is rolling out to general availability on all platforms. Check whether it appears in your build before you rely on it for a cleanup.

## Pivot tables on Mac: what works and what does not

Pivot tables are the fastest way to answer a question like how much did we spend on HVAC, by building. Build one from a clean Table. Select a cell inside the table, then go to Insert > PivotTable. Drag Building to Rows, Asset class to Columns and Amount to Values.

Know the Mac gaps first. Microsoft's support page says Power Pivot is not currently available on Excel for Mac. A third-party Mac comparison says pivot tables built from the Data Model cannot be filtered on a Mac, and dynamic PivotCharts are Windows-only. Test those claims on your own build before you plan a report around them.

Power Query has a gap too. Microsoft says shaping data in Power Query is generally available on Excel for Mac for Microsoft 365 subscribers on version 16.69 or later. Authoring queries in the Power Query Editor is not available on Mac. VBA can author Power Query queries, which is a route for IT staff rather than most facilities managers.

For a step-by-step pivot build, see [How to make a pivot table in Excel on Mac](https://www.lazur.app/how-to/make-a-pivot-table-in-excel). If a pivot does not pick up new rows, see [Excel pivot table not refreshing new rows on Mac](https://www.lazur.app/for/developers/problems/excel-pivot-table-not-refreshing-new-rows).

## Why Excel gets slow on a Mac, and what to do about it

Slow files usually come from how the file is built, not from size alone. A Microsoft Q&A thread describes Excel for Mac 16.70 on a 2018 MacBook Pro slowing and crashing on workbooks of 1 to 15 MB. Those files used lookups, conditional formatting and cross-workbook references. An MVP who looked into it said the problem was not running low on memory.

That thread is one user's report, not a survey. Still, the pattern matches common facilities files. An asset register that looks up data in a second workbook, with conditional formatting on every row, makes Excel work hard. Each recalculation touches both files.

Start with the cheap fixes. Move lookups into the same workbook. Replace links to other files with a values tab that you refresh on a schedule. Limit conditional formatting to the range you use, not whole columns.

1. Open Excel > About Excel and note the version. Microsoft's release notes list 16.114.3 as the current Mac build.
2. Delete old copies of the file, and keep one current version in OneDrive or SharePoint.
3. Save the cleaned file as a new name, then compare how fast it opens and recalculates.

> **Save a copy first:** Breaking a link turns a formula into a fixed value, and you cannot restore the formula afterward. Save a dated copy before you delete sheets or break links.

## Mistakes that quietly corrupt facilities spreadsheets

Panko's 2016 abstract, What We Don't Know About Spreadsheet Errors Today, gives a useful frame. It says errors are "rare on a per-cell basis." At the program level, though, "at least one incorrect bottom-line value is very likely to be present." Facilities files have many cells and many hands, so plan for that.

- Dates typed as text. Sorting puts them in the wrong order, and TODAY comparisons fail without warning.
- Merged cells inside the data. Filters and pivot tables skip the merged rows.
- Formulas that stop at a row. A new asset gets no next-due date until someone fills the formula down by hand.
- Duplicate asset IDs made by copying a row. Lookups return the first match and hide the second.
- Overwritten formulas. Someone types a number over a total, and nothing warns them.
- Filtered rows left hidden. The footer total ignores them, and nobody notices until the budget meeting.

Check each one with a quick pass. Select a date column and look at the status bar. If it shows a count but no sum, the column holds text rather than real dates. Fix the text first, then run the overdue flags again.

![A spreadsheet of schedules and costs open on a computer screen](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/facilities-managers-excel/excel-for-facilities-managers-on-mac-3-234743.jpg)

## Which Mac setup fits each facilities sheet

| Sheet | Best Excel setup on Mac | Limit to plan for |
| --- | --- | --- |
| PM schedule | Table with EDATE next-due dates and an overdue rule | No reminders, so someone must review the flags |
| Asset register | One row per asset, with a dropdown for status and location | Copied rows create duplicate IDs |
| Work-order log | Shared file in OneDrive or SharePoint with a status dropdown | Vendors say field staff cannot easily update it |
| Cost tracker | Lookups from a vendor code list, with TRIM on the codes | #N/A errors from stray spaces |
| Summary pivot | PivotTable built from the clean log | No Power Pivot, and Data Model pivots cannot be filtered on Mac |

_Setup options for the sheets most facilities teams keep, with limits from Microsoft and vendor notes._

## Asking Lazur for help while you work in Excel

Lazur sits beside Excel and answers from what is on your screen. Hold ⌥ ⌘, Option and Command together, and ask about anything you see. Lazur answers out loud. Ask where a button is, and Lazur draws a circle and a label around it. Ask how to do something, and Lazur guides you one click at a time, waiting for each click.

Lazur does not click for you. It does not edit your files or operate Excel. You make each change yourself. That keeps your data and your settings in your hands, which matters on a shared asset register.

Hold fn to dictate. The text goes at the cursor in any app, so you can speak a note into a work-order cell and then fix it by hand. Snippets, a personal dictionary and clipboard slots help with repeat wording, such as standard vendor notes.

Lazur keeps a memory of what you asked and did, and that memory stays on your Mac. It helps when you come back to a half-finished fix the next day.

Read the privacy terms before you ask about live asset data. Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer them, and they are not stored. Content is never used to train AI models. Check your company's rules before you send tenant, vendor or staff details to any AI service, Lazur included.

## What Lazur costs and how the trial works

Lazur starts with a 3-day Pro trial. No credit card is needed, and the trial starts when you first open the app. Use that window on a real PM schedule, not a practice file, so you learn what helps.

Pro costs $18 a month, or $15 a month billed annually, and includes 150 AI actions. Power costs $120 a month, or $96 a month billed annually, with 1,000 AI actions. Dictation is unlimited on both plans. Compare the details on the [pricing page](https://www.lazur.app/pricing).

Lazur runs on macOS, on Apple silicon and Intel Macs. Windows is planned, not available. If your team works on Windows, the menu paths on this page will not match your screen.

## Excel for Mac updates that affect facilities files

Microsoft updates Excel for Mac often. The current build in the release notes is 16.114.3, released October 27, 2026, with the note Quality and performance improvements. Check your build before a template or a shared file starts behaving differently.

Naming tables at creation reached Excel for Mac in October 2026, according to Microsoft's What's New post. That helps when a team shares a file with several tables. Use the same naming pattern in every file, such as tblAssets and tblWorkOrders.

Microsoft's release notes also list a PivotTable spill error behavior change in build 16.111, dated July 14, 2026. If your summary tabs use spilled formulas, test them after each update rather than assuming they still match.

## A weekly routine that keeps the file honest

A spreadsheet only works if someone maintains it. A maintenance software vendor's Excel PM template page says upkeep typically takes 5 to 10 hours a week of a coordinator's time. That figure cites no source, so time your own routine for a week and compare.

1. Monday: filter the Next due column for the coming weeks and review every flag.
2. Tuesday: close or reschedule each overdue row, and note the reason in the Status column.
3. Friday: check the cost tracker against new invoices, then run the #N/A check on the lookups.
4. Monthly: save a dated copy in OneDrive or SharePoint, then move closed work orders to an archive tab.

Keep the routine short. A routine you actually run beats a perfect file you stop opening. If a step takes too long, cut it, then check whether the file still answers the questions your manager asks.

## When Excel stops being enough for facilities work

Excel is a good place to start, and it can be a poor place to finish. Once several people must update work orders from site, or you need real alerts, a spreadsheet stops fitting the job. Maintenance software vendors make that case in their own template pages. Treat those claims as sales copy, and test any tool on your real data before you buy.

If you compare tools, check each vendor's pricing page for current prices, since prices change. Keep your Excel files as the record you export from. A clean asset register and a dated history make any later import much easier.

## Next steps for your Mac Excel setup

Start with one sheet this week. Build the PM schedule with the next-due formula and the overdue flag, then add the work-order log with its dropdown. Ask Lazur to point at any control you cannot find, and keep the clicks in your own hands.

For related setups, see [Excel for property managers on Mac](https://www.lazur.app/for/property-managers/excel) and [Excel for financial analysts on Mac](https://www.lazur.app/for/financial-analysts/excel). For the Excel assistant itself, read the [Excel page](https://www.lazur.app/apps/excel), then [download Lazur](https://www.lazur.app/download) when you are ready to try it.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Where is Conditional Formatting in this sheet?”: Lazur draws a circle and a label around Conditional Formatting on the Home tab, then says where it sits. (Points at it)
- “Where is Conditional Formatting in this sheet?”: Lazur circles Conditional Formatting on the Home tab and labels it on your screen.
- “Walk me through making the Status column a dropdown.”: Lazur guides you through Data > Data Validation one click at a time, waiting for each click.
- “Explain what this EDATE formula is doing.”: Lazur reads the formula aloud, explains the months argument, and says what the cell will show.
- “Dictate a note for this work order.”: Hold fn and speak. The text lands at the cursor, and you fix any wrong words by hand.
- “Draft a follow-up to the HVAC contractor about the late visit.”: Lazur drafts the message as text. You read it, change it and send it yourself.
- “Research typical service intervals for a rooftop unit and summarize them.”: Lazur runs the research in its own Chrome tabs and returns a summary and a report.
- “Remind me Friday to check the fire extinguisher log.”: Lazur adds the reminder to Apple Reminders for Friday.
- “Why is this lookup returning N/A?”: Lazur points at likely causes, such as stray spaces in the codes, and explains each fix.

## FAQ

### Is there a separate version of Excel for facilities managers on Mac?

No. Facilities teams use the same Excel for Mac app as everyone else, through Microsoft 365. The Mac gaps on this page apply to every role that uses the app, so plan your sheets around them.

### Does Power Pivot work in Excel for Mac?

Not currently. Microsoft's support page says Power Pivot is not currently available on Excel for Mac. Build summaries with a PivotTable on a clean Table, and test any Data Model pivot before you rely on it.

### Which Excel version is current on Mac?

Microsoft's release notes list Excel 16.114.3, build 26102720, released October 27, 2026. Open Excel > About Excel to see your version, then compare it with that entry.

### How do I stop overdue PM tasks from being missed in Excel?

Use an EDATE next-due formula, then add a conditional formatting rule that compares the next-due date with TODAY. Excel flags the row but does not send an alert, so pair the sheet with a fixed weekly review.

### Can Excel send reminders for work orders?

Not on its own. A CMMS vendor's template page says Excel work orders give no alert when a task is assigned, overdue or completed. Use calendar events or Apple Reminders for the due dates that matter most.

### Will Lazur edit my spreadsheet for me?

No. Lazur guides, points, explains, answers out loud, and drafts or types text when you ask. It does not click buttons or edit files, so you make each change yourself.

### Does Lazur work inside Excel?

No. Lazur is not a plugin for any app. It runs on your Mac beside Excel and answers from your screen while you hold the shortcut. It does not operate Excel for you.

## Sources

1. [Release notes for Office for Mac](https://learn.microsoft.com/en-us/officeupdates/release-notes-office-for-mac), Microsoft Learn, checked 2026-11-07
2. [What's New in Excel (October 2026)](https://techcommunity.microsoft.com/blog/excelblog/whats-new-in-excel-october-2026/4549758), Microsoft Tech Community, checked 2026-11-07
3. [Turn on Power Pivot](https://support.microsoft.com/en-au/office/turn-on-power-pivot-fcafdc01-3020-4d34-a6ce-f89391799836), Microsoft Support, checked 2026-11-07
4. [Import and shape data in Excel for Mac (Power Query)](https://support.microsoft.com/en-us/office/import-and-shape-data-in-excel-for-mac-power-query-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5), Microsoft Support, checked 2026-11-07
5. [2023 CMM In-House/Facility Management Benchmarking Survey Report](https://cmmonline.com/articles/2023-cmm-in-house-facility-management-benchmarking-survey-report), CMM (Cleaning Management Magazine), checked 2026-11-07
6. [What We Don't Know About Spreadsheet Errors Today](https://arxiv.org/abs/1602.02601), arXiv, checked 2026-11-07
7. [Free Work Order Templates Excel Downloads by eWorkOrders](https://eworkorders.com/cmms-industry-articles-eworkorders/free-work-order-templates-excel/), eWorkOrders, checked 2026-11-07
8. [Building Preventive Maintenance Schedule Template by Oxmaint](https://oxmaint.com/industries/facility-management/building-preventive-maintenance-schedule-template), Oxmaint, checked 2026-11-07
9. [Slow operation of Excel for Mac (Microsoft 365 Subscription)](https://learn.microsoft.com/en-us/answers/questions/5222196/slow-operation-of-excel-for-mac-microsoft-365-subs), Microsoft Q&A, checked 2026-11-07
10. [Excel for Mac vs Windows: What's Different in 2026](https://maccove.com/blog/excel-mac-vs-windows-differences), Maccove, checked 2026-11-07