One read of Claude Documentationclaude-docs-20260923T133722Z

claude-tag/admins/connections/amplitude New page · 108 lines, new page

# Connect Amplitude ## Choose an API key or Amplitude sign-in ## Get the API key and secret key from Amplitude ## Add the connection with an API key ## Add the connection with Amplitude sign-in ## Verify the connection ## Related resources

A whole new page. There's nothing to diff it against, so here is what it says.

# Connect Amplitude

> Connect Amplitude to Claude Tag with a project API key and secret key, or by signing in with Amplitude, so Claude can answer product-analytics questions.

export const BetaNote = () => <Info>Claude Tag is in public beta. Features and behavior described here may change before general availability.</Info>;

<BetaNote />

<Note>Connections are added inside an [Access bundle](/docs/claude-tag/admins/add-connections#your-first-access-bundle). At [`claude.ai/admin-settings/claude-tag`](https://claude.ai/admin-settings/claude-tag), open **Access bundles** in the left navigation, click into a bundle (or **Create** one), and go to its **Credentials** tab.</Note>

Connecting Amplitude lets Claude answer product-analytics questions, such as funnel and retention numbers, event segmentation, a user's recent activity, and cohort sizes, from any channel under the bundle's scope. You add it as a connection inside an [Access bundle](/docs/claude-tag/admins/add-connections); the credential belongs to the agent, not to any person.

You can connect with a project API key and secret key, which you can limit to read requests, or by signing in as an Amplitude user, which gives Claude Amplitude's MCP tools for creating and editing content as well as reading it.

For the API key route, pair the connection with a plugin that covers Amplitude so Claude knows how to call the REST API; see [Attach plugins](/docs/claude-tag/admins/add-connections#attach-plugins). A member's own Amplitude connector on claude.ai is separate from this connection and applies in DMs. In organizations where [personal connectors in channels](/docs/claude-tag/concepts/personal-connectors) is available, Claude can also use that connector in a channel for that member's own tasks, after the member allows it.

## Choose an API key or Amplitude sign-in

On a bundle's **Credentials** tab, clicking **Connect** next to **Amplitude** opens a form that offers two ways to connect: **Sign in with Amplitude**, selected by default, and **Use an API token** below it.

| Route                                              | What Claude can do                                                                                                                                                                                                                     | Amplitude data center | What you need                                                    |
| :------------------------------------------------- | :------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :-------------------- | :--------------------------------------------------------------- |
| **API key and secret key** (**Use an API token**)  | Run analytics queries, such as event segmentation, funnels, and retention, through Amplitude's [Dashboard REST API](https://amplitude.com/docs/apis/analytics/dashboard-rest). The setup steps restrict the key pair to read requests. | US or EU              | A project API key and a secret key generated for this connection |
| **Amplitude sign-in** (**Sign in with Amplitude**) | Work with charts, dashboards, cohorts, and experiments through Amplitude's MCP tools, which can create and edit content as well as read it. Claude acts in Amplitude with the signed-in user's roles and project access.               | US                    | A dedicated Amplitude user to sign in as                         |

Use the API key route when Claude should be limited to read requests. Also use the API key route when Amplitude hosts your organization's data in its EU data center (you sign in to Amplitude at `app.eu.amplitude.com` rather than `app.amplitude.com`), because the **Sign in with Amplitude** option connects to the MCP server for Amplitude's US data center, `https://mcp.amplitude.com/mcp`. Choose Amplitude sign-in when Claude should also build or change content in Amplitude, such as creating a chart or updating a dashboard.

With either route, Claude can use the connection in every channel under the bundle's scope. The form calls the sign-in option an MCP connector because Claude reaches Amplitude through Amplitude's hosted MCP server, and the result is still a connection in the bundle, not a personal claude.ai connector.

## Get the API key and secret key from Amplitude

The API key route uses two keys from one Amplitude project: the project's API key and a secret key. The connection sends them with HTTP Basic authentication, the API key as the username and the secret key as the password. Keys belong to a single project, so each connection reaches one project's data, and an organization with several Amplitude projects needs a key pair and a connection for each.

You need the Manager or Admin role in Amplitude to generate keys. Generate a secret key dedicated to this connection and give it a name that identifies Claude, so you can rotate or revoke it without affecting the keys your other tools use. Amplitude shows the secret key's value only once and can't display it again, so copy it as soon as it appears; if you lose it, generate a new secret key.

An Amplitude key pair has no read-only option, and the same pair can also call Amplitude's write and user-deletion endpoints. In the next section you restrict the connection to `GET` requests, so the key pair authenticates read requests only. Read access still covers everything those APIs return for the project, including raw event export and individual users' event streams, so scope the bundle to channels whose members may see that data.

Amplitude's own guide for creating the keys is at [amplitude.com](https://amplitude.com/docs/admin/account-management/manage-your-api-keys-and-secret-keys).

## Add the connection with an API key

A saved connection is live with every HTTP method in any channel under the bundle's scope. Add the connection to a bundle that isn't attached to a scope yet, and attach the bundle after you finish the restriction step below.

<Steps>
  <Step title="Open the Amplitude form">
    On the bundle's **Credentials** tab, click **Connect** next to **Amplitude**.
  </Step>

  <Step title="Enter the key pair">
    Select **Use an API token**, then fill in the two fields.

    | Field               | Value                                            |
    | :------------------ | :----------------------------------------------- |
    | Claude's API key    | The project's API key from Amplitude             |
    | Claude's secret key | The secret key you generated for this connection |

    The host is prefilled as `amplitude.com`. If Amplitude hosts your organization's data in its EU data center (you sign in to Amplitude at `app.eu.amplitude.com` rather than `app.amplitude.com`), replace the host with `analytics.eu.amplitude.com`.

    Click **Connect** to save the connection.
  </Step>

  <Step title="Restrict the connection to read requests">
    The connection is created with the `/api/` path prefix, which covers Amplitude's REST APIs and keeps the key pair off the rest of `amplitude.com`. Add the method restriction yourself: select **Edit** on the connection's row, then in the **Edit connection** dialog clear **All methods** under **Methods** and select `GET`. See [Restrict by path or method](/docs/claude-tag/admins/add-connections#restrict-by-path-or-method).

    With the restriction in place, the Agent Proxy attaches the key pair only to `GET` requests under `/api/`. A request outside that restriction, such as a write or a user-deletion call, doesn't match the connection. Agent Proxy never attaches the key pair to it, so the request can't authenticate to Amplitude.
  </Step>
</Steps>

Amplitude rate-limits these APIs per project, with a cap on concurrent requests and an hourly budget in which queries that span more days or segments cost more. Claude's queries draw on the same budget as your project's other API clients. If Claude reports that Amplitude returned a rate-limit error (HTTP 429), narrow the date range, drop a group-by, or ask again later. Amplitude's [Dashboard REST API documentation](https://amplitude.com/docs/apis/analytics/dashboard-rest) lists the current limits.

The Agent Proxy injects the credential at the network boundary; the model and the sandbox are not given the key. See [how Agent Proxy works](/docs/claude-tag/concepts/agent-identity#agent-proxy).

## Add the connection with Amplitude sign-in

<Warning>Sign in as a dedicated Amplitude user created for this connection (for example, `[email protected]`), not with your own account. Anyone in a channel under the bundle's scope can ask Claude to use the connection, so everything that user can reach in Amplitude is available to every member of those channels. Because Amplitude's MCP tools can create and edit charts, dashboards, and cohorts as well as read them, give the user the most limited role that covers what the channels need in each project, such as Viewer. A dedicated user also limits Claude to the projects you add that user to and keeps Claude's activity in Amplitude traceable to one account.</Warning>

This route connects to the MCP server for Amplitude's US data center. If you sign in to Amplitude at `app.eu.amplitude.com`, Amplitude hosts your organization's data in its EU data center, so use the [API key route](#add-the-connection-with-an-api-key) instead.

<Steps>
  <Step title="Open the Amplitude form">
    On the bundle's **Credentials** tab, click **Connect** next to **Amplitude**.
  </Step>

  <Step title="Sign in as the dedicated user">
    Leave **Sign in with Amplitude** selected. The **Sign in with Amplitude** option shows the MCP server the sign-in grants access to, `https://mcp.amplitude.com/mcp`, and the form sets the connection's allowed host to that server for you.

    Click **Sign in with Amplitude** at the bottom of the form. A sign-in window opens. If your browser blocks pop-ups, allow them for claude.ai and click **Sign in with Amplitude** again. Sign in to Amplitude as the dedicated user and approve access. When the sign-in completes and the window closes, the connection is saved to the bundle and appears on its **Credentials** tab.
  </Step>
</Steps>

Amplitude decides what the signed-in user can read and change, and that user's roles and project access apply to every request Claude makes through this connection. The `GET` restriction described for the API key route applies only to that route's key pair. If the sign-in succeeds but Claude reports that Amplitude denied a request, check the dedicated user's role and project access in Amplitude. See [Amplitude MCP](https://amplitude.com/docs/amplitude-ai/amplitude-mcp) for what Amplitude's MCP server can do.

## Verify the connection

In a channel under the bundle's scope, in a new thread:

```text wrap theme={null}
@Claude can you reach Amplitude? List a few of our event types.
```

With either route, Claude replies with event types from Amplitude once the connection is live. New threads pick up the connection on their own; in an existing thread, ask Claude to use Amplitude by name.

## Related resources

* [Answer data questions](/docs/claude-tag/users/use-cases/answer-data-questions): the question-to-chart pattern in a Slack thread, shown there with a data warehouse
* [Give Claude access](/docs/claude-tag/admins/add-connections): the full credential-type and allowed-hosts reference
* [Connect a custom service](/docs/claude-tag/admins/connections/custom): for Amplitude APIs the preset doesn't cover, such as the User Profile API, which lives on `profile-api.amplitude.com` and authenticates with a different header
* Amplitude's [API authentication](https://amplitude.com/docs/apis/authentication), [API key and secret key management](https://amplitude.com/docs/admin/account-management/manage-your-api-keys-and-secret-keys), and [Amplitude MCP](https://amplitude.com/docs/amplitude-ai/amplitude-mcp) documentation

office-agents/performance New page · 312 lines, new page

# Performance and limits ## Office runs one step at a time ## Limits to know ## File size and risk ## Limit what is open at once ## Lighter files respond faster ### Make large workbooks lighter ### Ask for formulas that calculate fast ### Pause calculation during large changes ### Make large presentations lighter ## When Office stops responding ## Investigate a crash or hang ### Collect the user's report ### Check Reliability Monitor ### Read Event Viewer ### Find Windows Error Reporting files ### Check the Office Telemetry Log ### Search your OpenTelemetry collector ## References

A whole new page. There's nothing to diff it against, so here is what it says.

# 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.<sup id="cite-ref-1-a" className="scroll-mt-24"><a href="#cite-note-1">\[1]</a></sup> 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.<sup id="cite-ref-1-b" className="scroll-mt-24"><a href="#cite-note-1">\[1]</a></sup>

<img src="https://mintcdn.com/claude-ai/_Xjykq_jOPUQ7vjH/images/office-agents/performance/perf-one-step.png?fit=max&auto=format&n=_Xjykq_jOPUQ7vjH&q=85&s=86e807e77450672873ddcbd4e16578d3" alt="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." width="1930" height="792" data-path="images/office-agents/performance/perf-one-step.png" />

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.<sup id="cite-ref-2" className="scroll-mt-24"><a href="#cite-note-2">\[2]</a></sup> If Office asks whether to
  keep running the add-in, continue.<sup id="cite-ref-3-a" className="scroll-mt-24"><a href="#cite-note-3">\[3]</a></sup>
* **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<sup id="cite-ref-3-b" className="scroll-mt-24"><a href="#cite-note-3">\[3]</a></sup>                                  | A larger read can fail                      |
| One request in Excel on the web             | 5 MB<sup id="cite-ref-3-c" className="scroll-mt-24"><a href="#cite-note-3">\[3]</a></sup>                                       | Large reads and writes can fail on the web  |
| Command batches waiting in Office           | 50<sup id="cite-ref-4-a" className="scroll-mt-24"><a href="#cite-note-4">\[4]</a></sup>                                         | More batches cause errors                   |
| Workbook opened in a browser                | Up to 100 MB, depending on your subscription<sup id="cite-ref-5" className="scroll-mt-24"><a href="#cite-note-5">\[5]</a></sup> | Open larger files in Excel on the desktop   |
| Memory for 32-bit Excel                     | Up to 4 GB on 64-bit Windows<sup id="cite-ref-6" className="scroll-mt-24"><a href="#cite-note-6">\[6]</a></sup>                 | 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.

<img src="https://mintcdn.com/claude-ai/_Xjykq_jOPUQ7vjH/images/office-agents/performance/perf-risk.png?fit=max&auto=format&n=_Xjykq_jOPUQ7vjH&q=85&s=c018954e584a7b8fe3712b69b226f106" alt="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." width="1890" height="1062" data-path="images/office-agents/performance/perf-risk.png" />

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.<sup id="cite-ref-7-a" className="scroll-mt-24"><a href="#cite-note-7">\[7]</a></sup> 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.<sup id="cite-ref-7-b" className="scroll-mt-24"><a href="#cite-note-7">\[7]</a></sup>

A single sheet above 5 million cells also passes the limit for one Office
read.<sup id="cite-ref-3-d" className="scroll-mt-24"><a href="#cite-note-3">\[3]</a></sup>

## 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.<sup id="cite-ref-8-a" className="scroll-mt-24"><a href="#cite-note-8">\[8]</a></sup> Every pane
sends its commands to that process. Office queues the command batches it
receives, up to 50 at a time.<sup id="cite-ref-4-b" className="scroll-mt-24"><a href="#cite-note-4">\[4]</a></sup> When the computer is short of CPU
or memory, the wait grows, and Excel can stall or crash.

<img src="https://mintcdn.com/claude-ai/_Xjykq_jOPUQ7vjH/images/office-agents/performance/perf-shared-process.png?fit=max&auto=format&n=_Xjykq_jOPUQ7vjH&q=85&s=524e1317ae5b08f66fe51b4dcf8373ae" alt="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." width="1890" height="872" data-path="images/office-agents/performance/perf-shared-process.png" />

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.<sup id="cite-ref-3-e" className="scroll-mt-24"><a href="#cite-note-3">\[3]</a></sup>

* 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.<sup id="cite-ref-8-b" className="scroll-mt-24"><a href="#cite-note-8">\[8]</a></sup>

## 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<sup id="cite-ref-9" className="scroll-mt-24"><a href="#cite-note-9">\[9]</a></sup>              |
| Remove formatting from empty cells         | Review, Check Performance<sup id="cite-ref-10-a" className="scroll-mt-24"><a href="#cite-note-10">\[10]</a></sup>           |
| Find hidden shapes and pictures            | Home, Find & Select, Selection Pane<sup id="cite-ref-11-a" className="scroll-mt-24"><a href="#cite-note-11">\[11]</a></sup> |

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.<sup id="cite-ref-10-b" className="scroll-mt-24"><a href="#cite-note-10">\[10]</a></sup>

If the workbook is still too large, copy the sheets you need into a new
workbook.<sup id="cite-ref-11-b" className="scroll-mt-24"><a href="#cite-note-11">\[11]</a></sup>

### 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.<sup id="cite-ref-12" className="scroll-mt-24"><a href="#cite-note-12">\[12]</a></sup>
* **Today's date**: TODAY in one cell, with other cells that refer to
  it.<sup id="cite-ref-11-c" className="scroll-mt-24"><a href="#cite-note-11">\[11]</a></sup>
* **Direct references**: cell references in place of OFFSET and INDIRECT,
  which recalculate at each recalculation.<sup id="cite-ref-13" className="scroll-mt-24"><a href="#cite-note-13">\[13]</a></sup>

### Pause calculation during large changes

Excel recalculates dependent formulas after every change. For large formula
changes, pause recalculation until Claude is done.

<Steps>
  <Step title="Set calculation to manual">
    On the Formulas tab, select Calculation Options, Manual.<sup id="cite-ref-14-a" className="scroll-mt-24"><a href="#cite-note-14">\[14]</a></sup>
    The option Automatic except for Data Tables skips only data tables.
    Ordinary formulas still recalculate after every change.
  </Step>

  <Step title="Ask Claude for the changes">
    Claude writes the formulas without a recalculation after each one.
  </Step>

  <Step title="Recalculate">
    Press F9 when Claude is done. In Manual mode, formula results stay out of
    date until you press F9.
  </Step>

  <Step title="Check the results">
    Ask Claude to verify the formulas after the recalculation.
  </Step>

  <Step title="Turn automatic calculation back on">
    Select Calculation Options, Automatic.
  </Step>
</Steps>

<Note>
  Manual calculation applies to every open workbook in Excel on the desktop.<sup id="cite-ref-15" className="scroll-mt-24"><a href="#cite-note-15">\[15]</a></sup>
  In Excel on the web it applies only to the current workbook. In Manual mode,
  saving can recalculate the workbook.<sup id="cite-ref-14-b" className="scroll-mt-24"><a href="#cite-note-14">\[14]</a></sup>
</Note>

### Make large presentations lighter

Large pictures and media make a presentation larger.<sup id="cite-ref-16-a" className="scroll-mt-24"><a href="#cite-note-16">\[16]</a></sup> 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<sup id="cite-ref-16-b" className="scroll-mt-24"><a href="#cite-note-16">\[16]</a></sup> |
| Compress audio and video | File, Info, Compress Media, in PowerPoint on Windows<sup id="cite-ref-17" className="scroll-mt-24"><a href="#cite-note-17">\[17]</a></sup>                           |

Save a copy of the presentation before you compress. Deleting cropped picture
areas and discarding editing data cannot be undone.<sup id="cite-ref-16-c" className="scroll-mt-24"><a href="#cite-note-16">\[16]</a></sup>

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.<sup id="cite-ref-18-a" className="scroll-mt-24"><a href="#cite-note-18">\[18]</a></sup> 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.

<Steps>
  <Step title="Recover your work">
    Reopen the app and look for the Document Recovery pane.<sup id="cite-ref-18-b" className="scroll-mt-24"><a href="#cite-note-18">\[18]</a></sup>
    In Excel, you can also go to File, Info, Manage Document, Recover Unsaved
    Workbooks.<sup id="cite-ref-19" className="scroll-mt-24"><a href="#cite-note-19">\[19]</a></sup>
  </Step>

  <Step title="Download the chat">
    In the Claude pane, select More options, then Download Transcript.
  </Step>

  <Step title="Send it to IT">
    Send the file and the time of the problem through your usual support
    channel. The file contains your chat.
  </Step>
</Steps>

## 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.

<img src="https://mintcdn.com/claude-ai/_Xjykq_jOPUQ7vjH/images/office-agents/performance/perf-where-to-look.png?fit=max&auto=format&n=_Xjykq_jOPUQ7vjH&q=85&s=d62ef0be87cdd199fb375df256ef2642" alt="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." width="1890" height="722" data-path="images/office-agents/performance/perf-where-to-look.png" />

### 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.<sup id="cite-ref-20" className="scroll-mt-24"><a href="#cite-note-20">\[20]</a></sup>

```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.<sup id="cite-ref-21" className="scroll-mt-24"><a href="#cite-note-21">\[21]</a></sup>
* **Event 1002**: a hang.<sup id="cite-ref-22" className="scroll-mt-24"><a href="#cite-note-22">\[22]</a></sup>

### Find Windows Error Reporting files

Windows Error Reporting keeps a report for each crash or hang. The reports
are in one of two folders.<sup id="cite-ref-23" className="scroll-mt-24"><a href="#cite-note-23">\[23]</a></sup>

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.<sup id="cite-ref-24" className="scroll-mt-24"><a href="#cite-note-24">\[24]</a></sup> It records events only after you turn on the
`EnableLogging` policy.<sup id="cite-ref-25" className="scroll-mt-24"><a href="#cite-note-25">\[25]</a></sup> Microsoft no longer supports the
Office Telemetry Dashboard but keeps the log.<sup id="cite-ref-26" className="scroll-mt-24"><a href="#cite-note-26">\[26]</a></sup>

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.

<ol>
  <li id="cite-note-1" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10">↑ <a href="#cite-ref-1-a" className="font-normal">a</a> <a href="#cite-ref-1-b" className="font-normal">b</a> “<a href="https://support.microsoft.com/en-us/excel/excel-not-responding-hangs-freezes-or-stops-working">Excel not responding, hangs, freezes or stops working</a>”. <em>Microsoft Support</em>. “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.</li>
  <li id="cite-note-2" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-2" className="font-normal">↑</a> “<a href="https://support.microsoft.com/en-us/office/refresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440">Refresh an external data connection in Excel</a>”. <em>Microsoft Support</em>.</li>
  <li id="cite-note-3" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10">↑ <a href="#cite-ref-3-a" className="font-normal">a</a> <a href="#cite-ref-3-b" className="font-normal">b</a> <a href="#cite-ref-3-c" className="font-normal">c</a> <a href="#cite-ref-3-d" className="font-normal">d</a> <a href="#cite-ref-3-e" className="font-normal">e</a> “<a href="https://learn.microsoft.com/en-us/office/dev/add-ins/concepts/resource-limits-and-performance-optimization">Resource limits and performance optimization for Office Add-ins</a>”. <em>Microsoft Learn</em>.</li>
  <li id="cite-note-4" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10">↑ <a href="#cite-ref-4-a" className="font-normal">a</a> <a href="#cite-ref-4-b" className="font-normal">b</a> “<a href="https://learn.microsoft.com/en-us/office/dev/add-ins/concepts/correlated-objects-pattern">Avoid using the context.sync method in loops</a>”. <em>Microsoft Learn</em>. “Office supports no more than 50 batch jobs in the queue. Any more triggers errors.”</li>
  <li id="cite-note-5" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-5" className="font-normal">↑</a> “<a href="https://support.microsoft.com/en-us/office/file-size-limits-for-workbooks-in-sharepoint-9e5bc6f8-018f-415a-b890-5452687b325e">File size limits for workbooks in SharePoint</a>”. <em>Microsoft Support</em>.</li>
  <li id="cite-note-6" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-6" className="font-normal">↑</a> “<a href="https://learn.microsoft.com/en-us/troubleshoot/microsoft-365-apps/excel/laa-capability-change">Large Address Aware capability change for Excel</a>”. <em>Microsoft Learn</em>.</li>
  <li id="cite-note-7" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10">↑ <a href="#cite-ref-7-a" className="font-normal">a</a> <a href="#cite-ref-7-b" className="font-normal">b</a> “<a href="https://support.microsoft.com/en-us/excel/locate-and-reset-the-last-cell-on-a-worksheet">Locate and reset the last cell on a worksheet</a>”. <em>Microsoft Support</em>.</li>
  <li id="cite-note-8" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10">↑ <a href="#cite-ref-8-a" className="font-normal">a</a> <a href="#cite-ref-8-b" className="font-normal">b</a> “<a href="https://support.microsoft.com/en-us/excel/tips-for-improving-excel-s-performance">Tips for improving Excel's performance</a>”. <em>Microsoft Support</em>. The page advises opening Excel in a new instance when several workbooks in one instance run out of memory.</li>
  <li id="cite-note-9" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-9" className="font-normal">↑</a> “<a href="https://support.microsoft.com/en-us/office/check-workbook-statistics-afa12d4b-9584-4826-99a8-33228467e006">Check Workbook Statistics</a>”. <em>Microsoft Support</em>.</li>
  <li id="cite-note-10" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10">↑ <a href="#cite-ref-10-a" className="font-normal">a</a> <a href="#cite-ref-10-b" className="font-normal">b</a> “<a href="https://support.microsoft.com/en-us/office/cleanup-cells-in-your-workbook-edcc579f-b82f-495b-8d31-e786cd11717b">Cleanup cells in your workbook</a>”. <em>Microsoft Support</em>.</li>
  <li id="cite-note-11" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10">↑ <a href="#cite-ref-11-a" className="font-normal">a</a> <a href="#cite-ref-11-b" className="font-normal">b</a> <a href="#cite-ref-11-c" className="font-normal">c</a> “<a href="https://learn.microsoft.com/en-us/troubleshoot/microsoft-365-apps/excel/clean-workbook-less-memory">Clean up an Excel workbook so that it uses less memory</a>”. <em>Microsoft Learn</em>.</li>
  <li id="cite-note-12" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-12" className="font-normal">↑</a> “<a href="https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructions">Excel performance: Tips for optimizing performance obstructions</a>”. <em>Microsoft Learn</em>. “You should always use the SUMIFS, COUNTIFS, and AVERAGEIFS functions instead of array formulas where you can because they are much faster to calculate.”</li>
  <li id="cite-note-13" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-13" className="font-normal">↑</a> “<a href="https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-improving-calculation-performance">Excel performance: Improving calculation performance</a>”. <em>Microsoft Learn</em>. “A volatile function is always recalculated at each recalculation even if it does not seem to have any changed precedents.”</li>
  <li id="cite-note-14" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10">↑ <a href="#cite-ref-14-a" className="font-normal">a</a> <a href="#cite-ref-14-b" className="font-normal">b</a> “<a href="https://support.microsoft.com/en-us/office/change-formula-recalculation-iteration-or-precision-in-excel-73fc7dac-91cf-4d36-86e8-67124f6bcce4">Change formula recalculation, iteration, or precision in Excel</a>”. <em>Microsoft Support</em>. 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.</li>
  <li id="cite-note-15" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-15" className="font-normal">↑</a> “<a href="https://learn.microsoft.com/en-us/troubleshoot/microsoft-365-apps/excel/current-mode-of-calculation">How Excel determines the current mode of calculation</a>”. <em>Microsoft Learn</em>. “Changing the calculation mode of one open document changes the mode for all open documents.”</li>

Cut at 300 lines. The page has the rest.