Home Docs Claude Documentation 23 Sep 2026

One change · claude-docs

Performance and limits changedoffice-agents/performance

Nearest release: v2.1.280, published 10 hours before upstream edited the page. Shown because the two are within 24 hours of each other. Nothing here says the release caused the edit.

Upstream edited this page at 23 Sep 2026 02:40 UTC, give or take a minute or two: the time comes from Anthropic’s own sitemap rather than from a commit. This site recorded the change at 20 Oct 2026 18:07 UTC.

Upstream edited 23 Sep 2026 02:40 UTC

Recorded here 20 Oct 2026 18:07 UTC

Lines+109added

Lines−113removed

From line 4 where the diff opens

First seen 23 Sep 2026 this site's first read of the page

Recorded edits4to this page, all time

The whole hunk

from line 4, old and new numbered

lines

from line 4

55Claude for M365 does its work inside your Office app. When a file has very

66large ranges, many shapes, or heavy formulas, the app can slow down or stop

7responding.<a href="#cite-note-1">\[1]</a> This happens with any heavy task in Office, with

7responding.[\[1\]](#cite-note-1) This happens with any heavy task in Office, with

88or without Claude.

1010## Office runs one step at a time

1111

1212Claude sends each step to Office and waits for Office to finish it. While

13Office is busy, other actions can stall too.<a href="#cite-note-1">\[1]</a>

13Office is busy, other actions can stall too.[\[1\]](#cite-note-1)

1414

15<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" />

15![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.](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)

1616

1717Four habits reduce slowdowns.

1818

1919* **Let each step finish**: do not click, type, edit, run macros, or start a

2020 data refresh while Claude works. If a refresh is already running, wait for

21 it or stop it with Esc or Stop Refresh.<a href="#cite-note-2">\[2]</a> If Office asks whether to

22 keep running the add-in, continue.<a href="#cite-note-3">\[3]</a>

21 it or stop it with Esc or Stop Refresh.[\[2\]](#cite-note-2) If Office asks whether to

22 keep running the add-in, continue.[\[3\]](#cite-note-3)

2323* **Give Claude only what the task needs**: name the sheet and range, or

2424 copy the sheets you need into a new workbook.

2525* **Ask for large changes one step at a time**: split a big job into

from line 37

3737| Wait for other steps, such as writing cells | 5 minutes on the desktop, 2 minutes on the web | A heavy step can time out |

3838| Wait for a Word text edit | 30 seconds | A heavy edit can time out |

3939| Cells returned by one Claude read in Excel | 2,000 cells with data | Claude reads a large sheet in several steps |

40| Cells Office reads from one range | 5,000,000<a href="#cite-note-3">\[3]</a> | A larger read can fail |

41| One request in Excel on the web | 5 MB<a href="#cite-note-3">\[3]</a> | Large reads and writes can fail on the web |

42| Command batches waiting in Office | 50<a href="#cite-note-4">\[4]</a> | More batches cause errors |

43| Workbook opened in a browser | Up to 100 MB, depending on your subscription<a href="#cite-note-5">\[5]</a> | Open larger files in Excel on the desktop |

44| Memory for 32-bit Excel | Up to 4 GB on 64-bit Windows<a href="#cite-note-6">\[6]</a> | Use 64-bit Office for large workbooks |

40| Cells Office reads from one range | 5,000,000[\[3\]](#cite-note-3) | A larger read can fail |

41| One request in Excel on the web | 5 MB[\[3\]](#cite-note-3) | Large reads and writes can fail on the web |

42| Command batches waiting in Office | 50[\[4\]](#cite-note-4) | More batches cause errors |

43| Workbook opened in a browser | Up to 100 MB, depending on your subscription[\[5\]](#cite-note-5) | Open larger files in Excel on the desktop |

44| Memory for 32-bit Excel | Up to 4 GB on 64-bit Windows[\[6\]](#cite-note-6) | Use 64-bit Office for large workbooks |

4545

4646## File size and risk

4747

from line 50

5050reload. Larger files also mean longer sessions. The chart is directional,

5151based on what Claude for M365 usage shows.

5252

53<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" />

53![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.](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)

5454

5555The risk rises steadily, without a sharp threshold. Treat the bands as guides.

5656

from line 60

6161

6262To estimate the total for a workbook, go to each sheet and press Ctrl+End to

63move to its last cell.<a href="#cite-note-7">\[7]</a> Multiply the number of the last row by the

63move to its last cell.[\[7\]](#cite-note-7) Multiply the number of the last row by the

6464number of the last column, then add the results for all sheets. A last cell

6565of Z100000 is column 26 and row 100,000, about 2.6 million cells. Formatting

6666on empty cells moves the last cell, so a sheet can count as larger than its

67data.<a href="#cite-note-7">\[7]</a>

67data.[\[7\]](#cite-note-7)

6868

6969A single sheet above 5 million cells also passes the limit for one Office

70read.<a href="#cite-note-3">\[3]</a>

70read.[\[3\]](#cite-note-3)

7171

7272## Limit what is open at once

7373

7474Workbooks that you open in the same instance of Excel share one Excel

75process, and each workbook has its own Claude pane.<a href="#cite-note-8">\[8]</a> Every pane

75process, and each workbook has its own Claude pane.[\[8\]](#cite-note-8) Every pane

7676sends its commands to that process. Office queues the command batches it

77receives, up to 50 at a time.<a href="#cite-note-4">\[4]</a> When the computer is short of CPU

77receives, up to 50 at a time.[\[4\]](#cite-note-4) When the computer is short of CPU

7878or memory, the wait grows, and Excel can stall or crash.

7979

80<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" />

80![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.](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)

8181

8282Other Office apps run in their own processes, but they share the same CPU and

8383memory. Office starts to monitor add-in memory when the device passes 80%

84memory use.<a href="#cite-note-3">\[3]</a>

84memory use.[\[3\]](#cite-note-3)

8585

8686* Close the files you are not working in.

8787* For large files, work in one file at a time.

from line 88

8888* When Claude works across Office apps, ask it to finish in one app before it

8989 moves to the next. See [Work across M365 apps](/docs/office-agents/work-across-apps).

9090* If Excel runs out of memory with several workbooks open, open Excel in a new

91 instance.<a href="#cite-note-8">\[8]</a>

91 instance.[\[8\]](#cite-note-8)

9292

9393## Lighter files respond faster

9494

from line 101

101101

102102| Task | Where in Excel |

103103| - | - |

104| See counts of cells, formulas, and objects | Review, Workbook Statistics<a href="#cite-note-9">\[9]</a> |

105| Remove formatting from empty cells | Review, Check Performance<a href="#cite-note-10">\[10]</a> |

106| Find hidden shapes and pictures | Home, Find & Select, Selection Pane<a href="#cite-note-11">\[11]</a> |

104| See counts of cells, formulas, and objects | Review, Workbook Statistics[\[9\]](#cite-note-9) |

105| Remove formatting from empty cells | Review, Check Performance[\[10\]](#cite-note-10) |

106| Find hidden shapes and pictures | Home, Find & Select, Selection Pane[\[11\]](#cite-note-11) |

107107

108108Save a copy of the workbook before you run Check Performance. It removes

109109formatting from cells that look empty, including cells used for pixel

110art.<a href="#cite-note-10">\[10]</a>

110art.[\[10\]](#cite-note-10)

111111

112112If the workbook is still too large, copy the sheets you need into a new

113workbook.<a href="#cite-note-11">\[11]</a>

113workbook.[\[11\]](#cite-note-11)

114114

115115### Ask for formulas that calculate fast

116116

from line 118

118118for these forms.

119119

120120* **Conditional sums and counts**: SUMIFS, COUNTIFS, and AVERAGEIFS. They

121 calculate much faster than array formulas.<a href="#cite-note-12">\[12]</a>

121 calculate much faster than array formulas.[\[12\]](#cite-note-12)

122122* **Today's date**: TODAY in one cell, with other cells that refer to

123 it.<a href="#cite-note-11">\[11]</a>

123 it.[\[11\]](#cite-note-11)

124124* **Direct references**: cell references in place of OFFSET and INDIRECT,

125 which recalculate at each recalculation.<a href="#cite-note-13">\[13]</a>

125 which recalculate at each recalculation.[\[13\]](#cite-note-13)

126126

127127### Pause calculation during large changes

128128

from line 129

129129Excel recalculates dependent formulas after every change. For large formula

130130changes, pause recalculation until Claude is done.

131131

132<Steps>

133 <Step title="Set calculation to manual">

134 On the Formulas tab, select Calculation Options, Manual.<a href="#cite-note-14">\[14]</a>

135 The option Automatic except for Data Tables skips only data tables.

136 Ordinary formulas still recalculate after every change.

137 </Step>

132**1. Set calculation to manual**

138133

139 <Step title="Ask Claude for the changes">

140 Claude writes the formulas without a recalculation after each one.

141 </Step>

134On the Formulas tab, select Calculation Options, Manual.[\[14\]](#cite-note-14)

135The option Automatic except for Data Tables skips only data tables.

136Ordinary formulas still recalculate after every change.

142137

143 <Step title="Recalculate">

144 Press F9 when Claude is done. In Manual mode, formula results stay out of

145 date until you press F9.

146 </Step>

138**2. Ask Claude for the changes**

147139

148 <Step title="Check the results">

149 Ask Claude to verify the formulas after the recalculation.

150 </Step>

140Claude writes the formulas without a recalculation after each one.

151141

152 <Step title="Turn automatic calculation back on">

153 Select Calculation Options, Automatic.

154 </Step>

155</Steps>

142**3. Recalculate**

156143

157<Note>

158 Manual calculation applies to every open workbook in Excel on the desktop.<a href="#cite-note-15">\[15]</a>

159 In Excel on the web it applies only to the current workbook. In Manual mode,

160 saving can recalculate the workbook.<a href="#cite-note-14">\[14]</a>

161</Note>

144Press F9 when Claude is done. In Manual mode, formula results stay out of

145date until you press F9.

162146

147**4. Check the results**

148

149Ask Claude to verify the formulas after the recalculation.

150

151**5. Turn automatic calculation back on**

152

153Select Calculation Options, Automatic.

154

155> [!NOTE]

156>

157> Manual calculation applies to every open workbook in Excel on the desktop.[\[15\]](#cite-note-15)

158> In Excel on the web it applies only to the current workbook. In Manual mode,

159> saving can recalculate the workbook.[\[14\]](#cite-note-14)

160

163161### Make large presentations lighter

164162

165Large pictures and media make a presentation larger.<a href="#cite-note-16">\[16]</a> Compress them

163Large pictures and media make a presentation larger.[\[16\]](#cite-note-16) Compress them

166164before you ask Claude for large changes.

167165

168166| Task | Where in PowerPoint |

169167| - | - |

170| Compress pictures | Picture Format, Compress Pictures, with "Apply only to this picture" cleared<a href="#cite-note-16">\[16]</a> |

171| Compress audio and video | File, Info, Compress Media, in PowerPoint on Windows<a href="#cite-note-17">\[17]</a> |

168| Compress pictures | Picture Format, Compress Pictures, with "Apply only to this picture" cleared[\[16\]](#cite-note-16) |

169| Compress audio and video | File, Info, Compress Media, in PowerPoint on Windows[\[17\]](#cite-note-17) |

172170

173171Save a copy of the presentation before you compress. Deleting cropped picture

174areas and discarding editing data cannot be undone.<a href="#cite-note-16">\[16]</a>

172areas and discarding editing data cannot be undone.[\[16\]](#cite-note-16)

175173

176174Ask Claude to change a few slides at a time.

177175

from line 181

183181| - | - |

184182| Claude waits on a step | Wait. Do not click repeatedly. |

185183| Claude reports a timeout | Wait until Office responds, save, then ask for a smaller step. The step can still be running in Office. |

186| Office closes | Reopen the file and look for the Document Recovery pane.<a href="#cite-note-18">\[18]</a> Start a new chat with a smaller request. |

184| Office closes | Reopen the file and look for the Document Recovery pane.[\[18\]](#cite-note-18) Start a new chat with a smaller request. |

187185| It happens often | Send your IT admin the transcript and the time of the problem. |

188186

189187When something goes wrong, keep your work and the chat for your admin.

190188

191<Steps>

192 <Step title="Recover your work">

193 Reopen the app and look for the Document Recovery pane.<a href="#cite-note-18">\[18]</a>

194 In Excel, you can also go to File, Info, Manage Document, Recover Unsaved

195 Workbooks.<a href="#cite-note-19">\[19]</a>

196 </Step>

189**1. Recover your work**

197190

198 <Step title="Download the chat">

199 In the Claude pane, select More options, then Download Transcript.

200 </Step>

191Reopen the app and look for the Document Recovery pane.[\[18\]](#cite-note-18)

192In Excel, you can also go to File, Info, Manage Document, Recover Unsaved

193Workbooks.[\[19\]](#cite-note-19)

201194

202 <Step title="Send it to IT">

203 Send the file and the time of the problem through your usual support

204 channel. The file contains your chat.

205 </Step>

206</Steps>

195**2. Download the chat**

207196

197In the Claude pane, select More options, then Download Transcript.

198

199**3. Send it to IT**

200

201Send the file and the time of the problem through your usual support

202channel. The file contains your chat.

203

208204## Investigate a crash or hang

209205

210206Windows, Office, and Claude each keep a record of what happened. Start with

from line 207

211207the time of the problem, then check the records below in order. The Windows

212208and Office records exist on Windows only.

213209

214<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" />

210![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.](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)

215211

216212### Collect the user's report

217213

from line 222

226222

227223Reliability Monitor shows a daily timeline of app crashes and hangs. Use it

228224to confirm that the problem happened and to see how often it repeats.

229Press Windows+R and run this command.<a href="#cite-note-20">\[20]</a>

225Press Windows+R and run this command.[\[20\]](#cite-note-20)

230226

231227```text theme={null}

232228perfmon /rel

from line 235

239235`POWERPNT.EXE`, `WINWORD.EXE`, or `OUTLOOK.EXE` near the time of the

240236problem.

241237

242* **Event 1000**: a crash. The event names the faulting module.<a href="#cite-note-21">\[21]</a>

243* **Event 1002**: a hang.<a href="#cite-note-22">\[22]</a>

238* **Event 1000**: a crash. The event names the faulting module.[\[21\]](#cite-note-21)

239* **Event 1002**: a hang.[\[22\]](#cite-note-22)

244240

245241### Find Windows Error Reporting files

246242

247243Windows Error Reporting keeps a report for each crash or hang. The reports

248are in one of two folders.<a href="#cite-note-23">\[23]</a>

244are in one of two folders.[\[23\]](#cite-note-23)

249245

250246The folder for the signed-in user:

251247

from line 258

262258### Check the Office Telemetry Log

263259

264260The Office Telemetry Log can list add-in CPU and runtime error

265events.<a href="#cite-note-24">\[24]</a> It records events only after you turn on the

266`EnableLogging` policy.<a href="#cite-note-25">\[25]</a> Microsoft no longer supports the

267Office Telemetry Dashboard but keeps the log.<a href="#cite-note-26">\[26]</a>

261events.[\[24\]](#cite-note-24) It records events only after you turn on the

262`EnableLogging` policy.[\[25\]](#cite-note-25) Microsoft no longer supports the

263Office Telemetry Dashboard but keeps the log.[\[26\]](#cite-note-26)

268264

269265After you turn on the policy, open this folder:

270266

from line 279

283279Microsoft documentation for the limits, steps, and file locations on this page.

284280

285281<ol>

286 <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>”. 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.</li>

287 <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>”. Microsoft Support.</li>

288 <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>”. Microsoft Learn.</li>

289 <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>”. Microsoft Learn. “Office supports no more than 50 batch jobs in the queue. Any more triggers errors.”</li>

290 <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>”. Microsoft Support.</li>

291 <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>”. Microsoft Learn.</li>

292 <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>”. Microsoft Support.</li>

293 <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>”. Microsoft Support. The page advises opening Excel in a new instance when several workbooks in one instance run out of memory.</li>

294 <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>”. Microsoft Support.</li>

295 <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>”. Microsoft Support.</li>

296 <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>”. Microsoft Learn.</li>

297 <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>”. 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.”</li>

298 <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>”. Microsoft Learn. “A volatile function is always recalculated at each recalculation even if it does not seem to have any changed precedents.”</li>

299 <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>”. 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.</li>

300 <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>”. Microsoft Learn. “Changing the calculation mode of one open document changes the mode for all open documents.”</li>

301 <li id="cite-note-16" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10">↑ <a href="#cite-ref-16-a" className="font-normal">a</a> <a href="#cite-ref-16-b" className="font-normal">b</a> <a href="#cite-ref-16-c" className="font-normal">c</a> “<a href="https://support.microsoft.com/en-us/powerpoint/reduce-the-file-size-of-your-powerpoint-presentations">Reduce the file size of your PowerPoint presentations</a>”. Microsoft Support. “if you delete the cropped picture data, you won't be able to restore it.” Discarding editing data also cannot be restored.</li>

302 <li id="cite-note-17" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-17" className="font-normal">↑</a> “<a href="https://support.microsoft.com/en-us/powerpoint/compress-your-media-files">Compress your media files</a>”. Microsoft Support.</li>

303 <li id="cite-note-18" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10">↑ <a href="#cite-ref-18-a" className="font-normal">a</a> <a href="#cite-ref-18-b" className="font-normal">b</a> “<a href="https://support.microsoft.com/en-us/office/collab-files/help-protect-your-files-in-case-of-a-crash">Help protect your files in case of a crash</a>”. Microsoft Support.</li>

304 <li id="cite-note-19" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-19" className="font-normal">↑</a> “<a href="https://support.microsoft.com/en-us/office/collab-files/recover-an-earlier-version-of-an-office-file">Recover an earlier version of an Office file</a>”. Microsoft Support.</li>

305 <li id="cite-note-20" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-20" className="font-normal">↑</a> “<a href="https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/perfmon">perfmon</a>”. Microsoft Learn. “/rel | Starts the Reliability Monitor.”</li>

306 <li id="cite-note-21" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-21" className="font-normal">↑</a> “<a href="https://learn.microsoft.com/en-us/troubleshoot/windows-server/performance/troubleshoot-application-service-crashing-behavior">Troubleshoot application or service crashing behavior</a>”. Microsoft Learn. “The Event ID 1000 with the Error level is the actual application crashing event.”</li>

307 <li id="cite-note-22" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-22" className="font-normal">↑</a> “<a href="https://learn.microsoft.com/en-us/answers/questions/5132051/excel-freeze-application-hang-error">Excel freeze: Application Hang error</a>”. Microsoft Q\&A. This is a community answer. Microsoft has no official page that names event 1002.</li>

308 <li id="cite-note-23" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-23" className="font-normal">↑</a> “<a href="https://learn.microsoft.com/en-us/windows-server/failover-clustering/troubleshooting-using-wer-reports">Troubleshooting a failover cluster using Windows Error Reporting</a>”. Microsoft Learn. “Windows Error Reporting Reports are stored in %ProgramData%\Microsoft\Windows\WER”. The per-user folder comes from “<a href="https://learn.microsoft.com/en-us/archive/blogs/oanapl/windows-error-reporting-wer-for-developers">Windows Error Reporting (WER) for developers</a>”. Microsoft Learn, archived. “The reports are usually saved at %localAppData%\Microsoft\Windows\WER”.</li>

309 <li id="cite-note-24" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-24" className="font-normal">↑</a> “<a href="https://learn.microsoft.com/en-us/office/client-developer/shared/troubleshooting-office-files-and-custom-solutions-with-the-telemetry-log">Troubleshooting Office files and custom solutions with the telemetry log</a>”. Microsoft Learn. , which lists the add-in events "Add-in used too much CPU" and "Add-in encountered runtime error".</li>

310 <li id="cite-note-25" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-25" className="font-normal">↑</a> “<a href="https://learn.microsoft.com/en-us/office/compatibility/deploy-telemetry-dashboard">Deploy Office Telemetry Dashboard</a>”. Microsoft Learn. “By default, data collection is disabled in Office.” The page gives the <code>%localappdata%\Microsoft\Office\16.0\Telemetry</code> path and the <code>EnableLogging</code> setting.</li>

311 <li id="cite-note-26" className="scroll-mt-24 target:bg-amber-100/60 dark:target:bg-amber-400/10"><a href="#cite-ref-26" className="font-normal">↑</a> “<a href="https://learn.microsoft.com/en-us/office/compatibility/telemetry-dashboard-removal">Removal of Office Telemetry Dashboard from Microsoft 365 Apps for enterprise</a>”. Microsoft Learn. “Office Telemetry Log isn't being removed and is still available on client devices running Windows.”</li>

282 <li id="cite-note-1">↑ [a](#cite-ref-1-a) [b](#cite-ref-1-b) “[Excel not responding, hangs, freezes or stops working](https://support.microsoft.com/en-us/excel/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.</li>

283 <li id="cite-note-2">[↑](#cite-ref-2) “[Refresh an external data connection in Excel](https://support.microsoft.com/en-us/office/refresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440)”. *Microsoft Support*.</li>

284 <li id="cite-note-3">↑ [a](#cite-ref-3-a) [b](#cite-ref-3-b) [c](#cite-ref-3-c) [d](#cite-ref-3-d) [e](#cite-ref-3-e) “[Resource limits and performance optimization for Office Add-ins](https://learn.microsoft.com/en-us/office/dev/add-ins/concepts/resource-limits-and-performance-optimization)”. *Microsoft Learn*.</li>

285 <li id="cite-note-4">↑ [a](#cite-ref-4-a) [b](#cite-ref-4-b) “[Avoid using the context.sync method in loops](https://learn.microsoft.com/en-us/office/dev/add-ins/concepts/correlated-objects-pattern)”. *Microsoft Learn*. “Office supports no more than 50 batch jobs in the queue. Any more triggers errors.”</li>

286 <li id="cite-note-5">[↑](#cite-ref-5) “[File size limits for workbooks in SharePoint](https://support.microsoft.com/en-us/office/file-size-limits-for-workbooks-in-sharepoint-9e5bc6f8-018f-415a-b890-5452687b325e)”. *Microsoft Support*.</li>

287 <li id="cite-note-6">[↑](#cite-ref-6) “[Large Address Aware capability change for Excel](https://learn.microsoft.com/en-us/troubleshoot/microsoft-365-apps/excel/laa-capability-change)”. *Microsoft Learn*.</li>

288 <li id="cite-note-7">↑ [a](#cite-ref-7-a) [b](#cite-ref-7-b) “[Locate and reset the last cell on a worksheet](https://support.microsoft.com/en-us/excel/locate-and-reset-the-last-cell-on-a-worksheet)”. *Microsoft Support*.</li>

289 <li id="cite-note-8">↑ [a](#cite-ref-8-a) [b](#cite-ref-8-b) “[Tips for improving Excel's performance](https://support.microsoft.com/en-us/excel/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.</li>

290 <li id="cite-note-9">[↑](#cite-ref-9) “[Check Workbook Statistics](https://support.microsoft.com/en-us/office/check-workbook-statistics-afa12d4b-9584-4826-99a8-33228467e006)”. *Microsoft Support*.</li>

291 <li id="cite-note-10">↑ [a](#cite-ref-10-a) [b](#cite-ref-10-b) “[Cleanup cells in your workbook](https://support.microsoft.com/en-us/office/cleanup-cells-in-your-workbook-edcc579f-b82f-495b-8d31-e786cd11717b)”. *Microsoft Support*.</li>

292 <li id="cite-note-11">↑ [a](#cite-ref-11-a) [b](#cite-ref-11-b) [c](#cite-ref-11-c) “[Clean up an Excel workbook so that it uses less memory](https://learn.microsoft.com/en-us/troubleshoot/microsoft-365-apps/excel/clean-workbook-less-memory)”. *Microsoft Learn*.</li>

293 <li id="cite-note-12">[↑](#cite-ref-12) “[Excel performance: Tips for optimizing performance obstructions](https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-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.”</li>

294 <li id="cite-note-13">[↑](#cite-ref-13) “[Excel performance: Improving calculation performance](https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-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.”</li>

295 <li id="cite-note-14">↑ [a](#cite-ref-14-a) [b](#cite-ref-14-b) “[Change formula recalculation, iteration, or precision in Excel](https://support.microsoft.com/en-us/office/change-formula-recalculation-iteration-or-precision-in-excel-73fc7dac-91cf-4d36-86e8-67124f6bcce4)”. *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.</li>

296 <li id="cite-note-15">[↑](#cite-ref-15) “[How Excel determines the current mode of calculation](https://learn.microsoft.com/en-us/troubleshoot/microsoft-365-apps/excel/current-mode-of-calculation)”. *Microsoft Learn*. “Changing the calculation mode of one open document changes the mode for all open documents.”</li>

297 <li id="cite-note-16">↑ [a](#cite-ref-16-a) [b](#cite-ref-16-b) [c](#cite-ref-16-c) “[Reduce the file size of your PowerPoint presentations](https://support.microsoft.com/en-us/powerpoint/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.</li>

298 <li id="cite-note-17">[↑](#cite-ref-17) “[Compress your media files](https://support.microsoft.com/en-us/powerpoint/compress-your-media-files)”. *Microsoft Support*.</li>

299 <li id="cite-note-18">↑ [a](#cite-ref-18-a) [b](#cite-ref-18-b) “[Help protect your files in case of a crash](https://support.microsoft.com/en-us/office/collab-files/help-protect-your-files-in-case-of-a-crash)”. *Microsoft Support*.</li>

300 <li id="cite-note-19">[↑](#cite-ref-19) “[Recover an earlier version of an Office file](https://support.microsoft.com/en-us/office/collab-files/recover-an-earlier-version-of-an-office-file)”. *Microsoft Support*.</li>

301 <li id="cite-note-20">[↑](#cite-ref-20) “[perfmon](https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/perfmon)”. *Microsoft Learn*. “/rel | Starts the Reliability Monitor.”</li>

302 <li id="cite-note-21">[↑](#cite-ref-21) “[Troubleshoot application or service crashing behavior](https://learn.microsoft.com/en-us/troubleshoot/windows-server/performance/troubleshoot-application-service-crashing-behavior)”. *Microsoft Learn*. “The Event ID 1000 with the Error level is the actual application crashing event.”</li>

303 <li id="cite-note-22">[↑](#cite-ref-22) “[Excel freeze: Application Hang error](https://learn.microsoft.com/en-us/answers/questions/5132051/excel-freeze-application-hang-error)”. *Microsoft Q\&A*. This is a community answer. Microsoft has no official page that names event 1002.</li>

304 <li id="cite-note-23">[↑](#cite-ref-23) “[Troubleshooting a failover cluster using Windows Error Reporting](https://learn.microsoft.com/en-us/windows-server/failover-clustering/troubleshooting-using-wer-reports)”. *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](https://learn.microsoft.com/en-us/archive/blogs/oanapl/windows-error-reporting-wer-for-developers)”. *Microsoft Learn, archived*. “The reports are usually saved at %localAppData%\Microsoft\Windows\WER”.</li>

305 <li id="cite-note-24">[↑](#cite-ref-24) “[Troubleshooting Office files and custom solutions with the telemetry log](https://learn.microsoft.com/en-us/office/client-developer/shared/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".</li>

306 <li id="cite-note-25">[↑](#cite-ref-25) “[Deploy Office Telemetry Dashboard](https://learn.microsoft.com/en-us/office/compatibility/deploy-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.</li>

307 <li id="cite-note-26">[↑](#cite-ref-26) “[Removal of Office Telemetry Dashboard from Microsoft 365 Apps for enterprise](https://learn.microsoft.com/en-us/office/compatibility/telemetry-dashboard-removal)”. *Microsoft Learn*. “Office Telemetry Log isn't being removed and is still available on client devices running Windows.”</li>

312308</ol>

313309

This page’s history 4 edits

23 Sep 2026 +2 −2
23 Sep 2026 +109 −113 · this one
23 Sep 2026 +30 −30
23 Sep 2026 +312 −0

The page’s own history →

Where it came from

The captureclaude-docs
Upstream pageclaude.com

Around it

Every changethe ledger
That day23 Sep 2026