Excel has no built-in audit rate limiter that automatically blocks a person or process after a set number of actions. You can use an event log and a formula to count activity within a time window, but that count is for monitoring: a workbook alone is not a reliable way to enforce a security or API rate limit.
What “audit rate limit” means in Excel
The phrase can refer to two different things. A rate limit is a rule that caps activity, such as no more than five requests in one minute. An audit is a record that helps someone review what happened, when it happened, and sometimes who did it. Excel can help analyze a record of events, but it does not provide a general setting that combines those jobs into an enforced limit.
For example, a team might want to know whether a service account generated more than 100 requests in an hour, or whether staff made too many changes to a shared workbook. The first question concerns the service or application receiving requests; its own platform sets and enforces API limits. The second concerns workbook activity, which Excel may show through collaboration features, but that is not the same as a complete, tamper-resistant audit log.
Excel worksheet capacity is also not a rate limit. A worksheet can contain up to 1,048,576 rows, but that maximum says nothing about how many edits or requests a person can make over time. If a message, service, or application reports that a rate limit was exceeded, check that product’s documentation and logs rather than looking for an Excel rate-limit setting.
What Excel can show about workbook changes
In Microsoft 365 for Windows, Review > Show Changes can display changes in a supported shared workbook, including information such as who changed what, where, and when. The panel is useful for investigating recent edits and understanding a collaboration issue. Its availability and the details shown can depend on the workbook, account, and Excel version; it should not be treated as a permanent compliance record.
For a workbook stored in OneDrive or SharePoint, version history can help recover or compare earlier saved versions. In Excel for Windows, check File > Info > Version History when the option is available. Excel for the web and Excel for Mac also provide version-history access for supported cloud files, though the exact interface can differ. Version history is valuable for recovery, but it is not necessarily a detailed log of every action or a way to count requests in a rolling time window.
These features are different from sheet protection. Review > Protect Sheet can restrict certain editing actions, but it does not create an audit trail or enforce a per-user activity quota. Similarly, hiding a worksheet or locking cells is not a substitute for access control on the file or the system that processes the activity.
Build a simple event log in a worksheet
To count activity, first record one event per row. A small log could use column A for the event timestamp and column B for the user or service identifier. Add other useful fields, such as event type, workbook name, request ID, or outcome, if they are available. Use Insert > Table to make the range easier to filter and extend as new rows are added.
For example, a log might contain these records:
- 2026-11-03 09:10, account-A, export
- 2026-11-03 09:35, account-A, export
- 2026-11-03 10:00, account-A, export
- 2026-11-03 08:59, account-A, export
Use genuine Excel date-and-time values in the timestamp column, not text that merely looks like a date. Consistent time zones matter too: if one data source records UTC and another records local time, convert them to a common basis before judging activity. Keep a stable identifier for each account; display names can change or be duplicated.
A formula such as NOW() is not a permanent event timestamp: it recalculates, so it can change after the row is entered. For a review log, import timestamps from the source system or enter and preserve a fixed value. If timestamps are edited later, the resulting count may no longer represent the original activity. Keep an unaltered source export when the log is important.
Count events in a rolling hour
With timestamps in A2:A1000, user IDs in B2:B1000, the user to check in D2, and a fixed audit cutoff date and time in E1, use this formula to count that user’s events in the hour ending at the cutoff:
=COUNTIFS($B$2:$B$1000,D2,$A$2:$A$1000,
Related
- Excel Merge Cells and Combine Text: How They Differ
- Excel Merge Cells: Combine Content Without Losing Data
- Excel Merge Blank Cells Below: Steps and Alternatives
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Percentile Rank in Excel: Find and Format ItTo find a value’s percentile rank in Excel, use =PERCENTRANK.INC($A$2:$A$6,B2), replacing the range with your comparison data and…
- Power Query Circular Reference: Causes and FixesA Power Query circular reference happens when a query depends on itself, either directly or through other queries,…
- Remove All Formatting in Word Without Losing TextTo remove formatting from a Word document, save a copy, press Ctrl+A on Windows (Command+A on Mac), then…
- Outlook Archive Shortcut: Keys for Windows, Mac, and WebIn classic Outlook for Windows, select an email and press Backspace to archive it. In new Outlook and…
- Data Validation Checklist for Excel: What to CheckA practical data validation checklist starts by defining what each field may contain, then applying the right Excel…
- Does Excel Have Box Plots? How to Create OneYes. Microsoft Excel for Microsoft 365 includes a built-in Box and Whisker chart, which is Excel’s name for…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.