Excel Audit Rate Limits: What They Mean and How to Track

How-to basics · Updated November 19, 2026

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

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.