When you open an Excel file protected by a Microsoft Purview Information Protection sensitivity label, Copilot may behave differently than it does on unlabeled files. Copilot cannot read, summarize, or generate content from cells that are restricted by a label that applies encryption or permissions. This article explains exactly what happens when you try to … Read more
You want to ask Copilot a question that needs data from two or more open Excel workbooks. By default, Copilot in Excel works on the active sheet or table in the current workbook. It cannot natively query across separate files. This article explains the current limitations and shows you the practical workarounds to combine data … Read more
Business users often ask whether Copilot runs faster in Excel for the web or in the Excel desktop app. The answer depends on hardware, data size, and network conditions. Excel Desktop uses your local CPU and RAM directly, while Excel Web relies on cloud servers and your internet connection. This article compares the performance of … Read more
When a formula in Excel returns a #REF! error or a broken reference, it can stop your entire spreadsheet from calculating correctly. These errors often appear after you move, delete, or rename cells, worksheets, or external workbooks that a formula depends on. Copilot in Excel can analyze your formulas and identify the exact source of … Read more
Copilot in Excel helps you analyze data, generate formulas, and create charts using natural language prompts. However, Copilot cannot read or process any data from encrypted workbooks. When you open a password-protected or encrypted Excel file, Copilot remains inactive and shows an error message in the Copilot pane. This limitation is by design to protect … Read more
You need to summarize a large dataset in Excel, but building a Pivot Table manually takes time and requires knowing which fields to drag into Rows, Columns, and Values. Copilot in Excel can create a Pivot Table from your data with a single natural-language request. This article explains the prerequisites, walks through the exact steps … Read more
Writing complex Excel formulas from scratch takes time and requires remembering the correct syntax for functions like XLOOKUP, SUMIFS, or nested IF statements. Copilot in Excel can generate these formulas automatically when you describe what you want in plain English. This feature works by interpreting your natural language request and translating it into the appropriate … Read more
You open Excel, type a prompt in Copilot, and it responds with an error that it cannot read your workbook. This stops you from using Copilot to analyze data, create charts, or write formulas. The problem usually happens because the workbook is in an unsupported format, has protected sheets, or Copilot lacks the required permissions. … Read more
You have an Excel spreadsheet with hundreds or thousands of rows. Scrolling through every cell to find the key numbers takes too long. Copilot can read your data and write a plain‑English summary of the totals, averages, or trends you need. This article shows you exactly which commands to type and which settings to check … Read more
You have a dataset in Excel and need to spot data points that fall far outside the normal range. Manually scanning hundreds of rows for outliers is slow and error-prone. Copilot in Excel can analyze your data and apply conditional formatting to highlight these extreme values automatically. This article explains how to set up your … Read more