> ## Documentation Index > Fetch the complete documentation index at: https://claude.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # Performance and limits > How Claude for M365 works with a busy Office app, the size limits to know, and what to do when Office slows down or stops responding. Claude for M365 does its work inside your Office app. When a file has very large ranges, many shapes, or heavy formulas, the app can slow down or stop responding.\[1] This happens with any heavy task in Office, with or without Claude. ## Office runs one step at a time Claude sends each step to Office and waits for Office to finish it. While Office is busy, other actions can stall too.\[1] Claude sends a step and waits. Office runs the step, for example a recalculation, a large read, or a big slide edit. At the wait limit, Claude reports a timeout, but Office is still running the step. The wait limit is 90 seconds for steps where Claude runs code, 5 minutes for other steps, and 2 minutes on the web. Stop and a timeout end Claude's wait, not the step Office already started. Four habits reduce slowdowns. * **Let each step finish**: do not click, type, edit, run macros, or start a data refresh while Claude works. If a refresh is already running, wait for it or stop it with Esc or Stop Refresh.\[2] If Office asks whether to keep running the add-in, continue.\[3] * **Give Claude only what the task needs**: name the sheet and range, or copy the sheets you need into a new workbook. * **Ask for large changes one step at a time**: split a big job into smaller requests. * **Wait after a timeout**: let Office respond, save, then ask for a smaller step. ## Limits to know These limits come from Claude for M365 and from Office itself. | Limit | Value | What it means for you | | ------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------- | | Wait for a step where Claude runs code | 90 seconds | A heavy step can time out | | Wait for other steps, such as writing cells | 5 minutes on the desktop, 2 minutes on the web | A heavy step can time out | | Wait for a Word text edit | 30 seconds | A heavy edit can time out | | Cells returned by one Claude read in Excel | 2,000 cells with data | Claude reads a large sheet in several steps | | Cells Office reads from one range | 5,000,000\[3] | A larger read can fail | | One request in Excel on the web | 5 MB\[3] | Large reads and writes can fail on the web | | Command batches waiting in Office | 50\[4] | More batches cause errors | | Workbook opened in a browser | Up to 100 MB, depending on your subscription\[5] | Open larger files in Excel on the desktop | | Memory for 32-bit Excel | Up to 4 GB on 64-bit Windows\[6] | Use 64-bit Office for large workbooks | ## File size and risk Sessions with larger files more often end with a step that never finished. This is how Claude for M365 detects an Office crash, a force quit, or a reload. Larger files also mean longer sessions. The chart is directional, based on what Claude for M365 usage shows. Directional chart of risk by file size. In Excel, measured by total used cells across all sheets, risk is lowest under 1 million cells, higher from 1 to 5 million, and highest over 5 million. In PowerPoint, measured by slides, risk is lowest under 100 slides, higher from 100 to 199, and highest at 200 or more. The chart shows direction, not measured values. The risk rises steadily, without a sharp threshold. Treat the bands as guides. | File | Works well | Higher risk, so narrow your requests | Use at your own risk | | ----------------------------------------- | --------------- | ------------------------------------ | -------------------- | | Excel, total used cells across all sheets | Under 1 million | 1 to 5 million | Over 5 million | | PowerPoint, slides | Under 100 | 100 to 199 | 200 or more | To estimate the total for a workbook, go to each sheet and press Ctrl+End to move to its last cell.\[7] Multiply the number of the last row by the number of the last column, then add the results for all sheets. A last cell of Z100000 is column 26 and row 100,000, about 2.6 million cells. Formatting on empty cells moves the last cell, so a sheet can count as larger than its data.\[7] A single sheet above 5 million cells also passes the limit for one Office read.\[3] ## Limit what is open at once Workbooks that you open in the same instance of Excel share one Excel process, and each workbook has its own Claude pane.\[8] Every pane sends its commands to that process. Office queues the command batches it receives, up to 50 at a time.\[4] When the computer is short of CPU or memory, the wait grows, and Excel can stall or crash. One Excel process contains three workbooks, each with its own Claude pane. The commands from all three panes go into a single command queue in the same process. The process runs on a computer with limited CPU and memory. When CPU and memory run short, waits grow and Excel can stall or crash. Keep only the files you need open. Other Office apps run in their own processes, but they share the same CPU and memory. Office starts to monitor add-in memory when the device passes 80% memory use.\[3] * Close the files you are not working in. * For large files, work in one file at a time. * When Claude works across Office apps, ask it to finish in one app before it moves to the next. See [Work across M365 apps](/docs/office-agents/work-across-apps). * If Excel runs out of memory with several workbooks open, open Excel in a new instance.\[8] ## Lighter files respond faster A smaller used range and lighter formulas shorten the time Office needs for each step. ### Make large workbooks lighter Excel has built-in tools that show what makes a workbook heavy. | Task | Where in Excel | | ------------------------------------------ | --------------------------------------------------------------------------------------------------------------------------- | | See counts of cells, formulas, and objects | Review, Workbook Statistics\[9] | | Remove formatting from empty cells | Review, Check Performance\[10] | | Find hidden shapes and pictures | Home, Find & Select, Selection Pane\[11] | Save a copy of the workbook before you run Check Performance. It removes formatting from cells that look empty, including cells used for pixel art.\[10] If the workbook is still too large, copy the sheets you need into a new workbook.\[11] ### Ask for formulas that calculate fast Some formulas make Excel recalculate far more cells than others. Ask Claude for these forms. * **Conditional sums and counts**: SUMIFS, COUNTIFS, and AVERAGEIFS. They calculate much faster than array formulas.\[12] * **Today's date**: TODAY in one cell, with other cells that refer to it.\[11] * **Direct references**: cell references in place of OFFSET and INDIRECT, which recalculate at each recalculation.\[13] ### Pause calculation during large changes Excel recalculates dependent formulas after every change. For large formula changes, pause recalculation until Claude is done. On the Formulas tab, select Calculation Options, Manual.\[14] The option Automatic except for Data Tables skips only data tables. Ordinary formulas still recalculate after every change. Claude writes the formulas without a recalculation after each one. Press F9 when Claude is done. In Manual mode, formula results stay out of date until you press F9. Ask Claude to verify the formulas after the recalculation. Select Calculation Options, Automatic. Manual calculation applies to every open workbook in Excel on the desktop.\[15] In Excel on the web it applies only to the current workbook. In Manual mode, saving can recalculate the workbook.\[14] ### Make large presentations lighter Large pictures and media make a presentation larger.\[16] Compress them before you ask Claude for large changes. | Task | Where in PowerPoint | | ------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Compress pictures | Picture Format, Compress Pictures, with "Apply only to this picture" cleared\[16] | | Compress audio and video | File, Info, Compress Media, in PowerPoint on Windows\[17] | Save a copy of the presentation before you compress. Deleting cropped picture areas and discarding editing data cannot be undone.\[16] Ask Claude to change a few slides at a time. ## When Office stops responding Use this table when Office stops responding during a request. | Situation | What to do | | ------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Claude waits on a step | Wait. Do not click repeatedly. | | Claude reports a timeout | Wait until Office responds, save, then ask for a smaller step. The step can still be running in Office. | | Office closes | Reopen the file and look for the Document Recovery pane.\[18] Start a new chat with a smaller request. | | It happens often | Send your IT admin the transcript and the time of the problem. | When something goes wrong, keep your work and the chat for your admin. Reopen the app and look for the Document Recovery pane.\[18] In Excel, you can also go to File, Info, Manage Document, Recover Unsaved Workbooks.\[19] In the Claude pane, select More options, then Download Transcript. Send the file and the time of the problem through your usual support channel. The file contains your chat. ## Investigate a crash or hang Windows, Office, and Claude each keep a record of what happened. Start with the time of the problem, then check the records below in order. The Windows and Office records exist on Windows only. Four sources of records, in order. First, the user: the time of the problem, which is the key to every record, and the transcript of what Claude was doing. Second, Windows only: Reliability Monitor with a daily crash and hang timeline, Event Viewer with event 1000 for a crash and 1002 for a hang, and Windows Error Reporting files for crashes and hangs. Third, Office: the Telemetry Log with add-in CPU and error events, which stays off until an admin enables it. Fourth, your collector: an OpenTelemetry trace for every user turn. ### Collect the user's report The time of the problem is the key to every other record. Ask the user for the time, the Office app, and whether Office closed or stopped responding. Then ask the user to select More options in the Claude pane, then Download Transcript. The transcript shows what Claude was doing when the problem started. ### Check Reliability Monitor Reliability Monitor shows a daily timeline of app crashes and hangs. Use it to confirm that the problem happened and to see how often it repeats. Press Windows+R and run this command.\[20] ```text theme={null} perfmon /rel ``` ### Read Event Viewer Event Viewer separates a crash from a hang. Open Event Viewer, select Windows Logs, then Application. Look for events from `EXCEL.EXE`, `POWERPNT.EXE`, `WINWORD.EXE`, or `OUTLOOK.EXE` near the time of the problem. * **Event 1000**: a crash. The event names the faulting module.\[21] * **Event 1002**: a hang.\[22] ### Find Windows Error Reporting files Windows Error Reporting keeps a report for each crash or hang. The reports are in one of two folders.\[23] The folder for the signed-in user: ```text theme={null} %LOCALAPPDATA%\Microsoft\Windows\WER\ReportArchive ``` The folder for the whole machine: ```text theme={null} C:\ProgramData\Microsoft\Windows\WER\ReportArchive ``` ### Check the Office Telemetry Log The Office Telemetry Log can list add-in CPU and runtime error events.\[24] It records events only after you turn on the `EnableLogging` policy.\[25] Microsoft no longer supports the Office Telemetry Dashboard but keeps the log.\[26] After you turn on the policy, open this folder: ```text theme={null} %LOCALAPPDATA%\Microsoft\Office\16.0\Telemetry ``` ### Search your OpenTelemetry collector Claude sends one trace for every user turn, including steps that failed. Search your collector for traces at the time of the problem. See [Configure a custom OpenTelemetry collector](/docs/office-agents/opentelemetry). ## References Microsoft documentation for the limits, steps, and file locations on this page.
  1. ↑ a b “Excel not responding, hangs, freezes or stops working”. Microsoft Support. “If you try to perform other actions while Excel is in use, Excel may not respond.” The page also lists whole-column references, many hidden objects, excessive styles, and large numbers of shapes as causes of slowness.
  2. ↑ “Refresh an external data connection in Excel”. Microsoft Support.
  3. ↑ a b c d e “Resource limits and performance optimization for Office Add-ins”. Microsoft Learn.
  4. ↑ a b “Avoid using the context.sync method in loops”. Microsoft Learn. “Office supports no more than 50 batch jobs in the queue. Any more triggers errors.”
  5. ↑ “File size limits for workbooks in SharePoint”. Microsoft Support.
  6. ↑ “Large Address Aware capability change for Excel”. Microsoft Learn.
  7. ↑ a b “Locate and reset the last cell on a worksheet”. Microsoft Support.
  8. ↑ a b “Tips for improving Excel's performance”. Microsoft Support. The page advises opening Excel in a new instance when several workbooks in one instance run out of memory.
  9. ↑ “Check Workbook Statistics”. Microsoft Support.
  10. ↑ a b “Cleanup cells in your workbook”. Microsoft Support.
  11. ↑ a b c “Clean up an Excel workbook so that it uses less memory”. Microsoft Learn.
  12. ↑ “Excel performance: Tips for optimizing performance obstructions”. Microsoft Learn. “You should always use the SUMIFS, COUNTIFS, and AVERAGEIFS functions instead of array formulas where you can because they are much faster to calculate.”
  13. ↑ “Excel performance: Improving calculation performance”. Microsoft Learn. “A volatile function is always recalculated at each recalculation even if it does not seem to have any changed precedents.”
  14. ↑ a b “Change formula recalculation, iteration, or precision in Excel”. Microsoft Support. The page covers the Manual and Automatic except for Data Tables options, the desktop and web scope, and the "Recalculate workbook before saving" setting that Manual turns on.
  15. ↑ “How Excel determines the current mode of calculation”. Microsoft Learn. “Changing the calculation mode of one open document changes the mode for all open documents.”
  16. ↑ a b c “Reduce the file size of your PowerPoint presentations”. Microsoft Support. “if you delete the cropped picture data, you won't be able to restore it.” Discarding editing data also cannot be restored.
  17. ↑ “Compress your media files”. Microsoft Support.
  18. ↑ a b “Help protect your files in case of a crash”. Microsoft Support.
  19. ↑ “Recover an earlier version of an Office file”. Microsoft Support.
  20. ↑ “perfmon”. Microsoft Learn. “/rel | Starts the Reliability Monitor.”
  21. ↑ “Troubleshoot application or service crashing behavior”. Microsoft Learn. “The Event ID 1000 with the Error level is the actual application crashing event.”
  22. ↑ “Excel freeze: Application Hang error”. Microsoft Q\&A. This is a community answer. Microsoft has no official page that names event 1002.
  23. ↑ “Troubleshooting a failover cluster using Windows Error Reporting”. Microsoft Learn. “Windows Error Reporting Reports are stored in %ProgramData%\Microsoft\Windows\WER”. The per-user folder comes from “Windows Error Reporting (WER) for developers”. Microsoft Learn, archived. “The reports are usually saved at %localAppData%\Microsoft\Windows\WER”.
  24. ↑ “Troubleshooting Office files and custom solutions with the telemetry log”. Microsoft Learn. , which lists the add-in events "Add-in used too much CPU" and "Add-in encountered runtime error".
  25. ↑ “Deploy Office Telemetry Dashboard”. Microsoft Learn. “By default, data collection is disabled in Office.” The page gives the %localappdata%\Microsoft\Office\16.0\Telemetry path and the EnableLogging setting.
  26. ↑ “Removal of Office Telemetry Dashboard from Microsoft 365 Apps for enterprise”. Microsoft Learn. “Office Telemetry Log isn't being removed and is still available on client devices running Windows.”