Getting started

Excel Copilot not working? Licence, file and data checks that matter

Excel Copilot not working or greyed out? Check licence, version, file location and table format, then use a plain SUMIFS fallback on a worked expenses sheet.

Editorial illustration for Excel Copilot not working? Licence, file and data checks that matter

When Excel Copilot is missing, greyed out or returns nothing useful, the cause is usually one of three things: your licence does not include it, your file is not in a form it can read, or the app is out of date. Check those in that order. If it still fails, a few ordinary formulas will give you the same answers for expense sheets.

Is Copilot included in your plan?

Copilot in Excel is tied to specific Microsoft plans and add-ons, and a regular Excel purchase does not necessarily include it. Open your account page and see which subscription you have, or ask the person who manages licences if your Excel comes from work or college. Availability and conditions change over time, so check Microsoft's current information instead of relying on a forum reply.

What file and data problems stop it working?

  • The workbook may need to be saved in the cloud with autosave on, rather than as a file on your desktop. If the button is greyed out, check the file location first.
  • Copilot generally works best when your data is formatted as a proper Excel table with a single header row and no blank rows or columns.
  • Merged cells, two header rows and totals sitting inside the data confuse most automated analysis.
  • Very large sheets may be slower or limited; try a copy with fewer rows to test.

How do you turn your data into a table?

  1. Click any cell inside your expense list.
  2. Press Ctrl and T, and confirm that the table has headers.
  3. Give the table a name on the Table Design tab, such as Expenses.
  4. Make sure each column holds one kind of thing: dates only in Date, numbers only in Amount.

What should you check in the app itself?

  1. Update Excel through the Account menu or your store.
  2. Sign out and back in with the work or personal account that holds the licence.
  3. Check that you are not in Protected View or opening the file read-only.
  4. Try the web version in a browser to see whether the desktop app is the issue.

A fallback that does not need Copilot

Say column A holds Category, column B holds Date and column C holds Amount, with data in rows 2 to 500, and you want food spending since a date typed in E1. In Excel 2007 and later, this works:

  • =SUMIFS($C$2:$C$500, $A$2:$A$500, "Food", $B$2:$B$500, ">="&$E$1)
  • Total for the whole month of November, with dates in E1 and F1: =SUMIFS($C$2:$C$500, $B$2:$B$500, ">="&$E$1, $B$2:$B$500, "<="&$F$1)
  • Number of food entries: =COUNTIFS($A$2:$A$500, "Food")

Suppose Food rows after the date are ₹420, ₹1,150 and ₹260. The formula returns ₹1,830, which you can confirm by adding them yourself: 420 plus 1,150 is 1,570, plus 260 is 1,830. If you want a quick category summary, select the table and insert a PivotTable with Category in Rows and Amount in Values.

When a spreadsheet stops being enough

A sheet is fine until you have several accounts, months of rows and a lot of manual tagging. At that point, SpendixAI can import statements as PDF, CSV or Excel, categorise with your own rules first, and let you download reports as CSV. Teach the formulas first, though; they make you better at reading any report.

What about Google Sheets?

If you use Google Sheets, the same SUMIFS idea works with identical argument order, and you can add a pivot table from the Insert menu. Copilot is a Microsoft feature, so a different assistant in Sheets has its own requirements; check Google's pages for what your plan includes. The formulas above need no assistant at all.

A last short checklist

  • Licence confirmed on the account page.
  • File saved to the cloud with autosave on.
  • Data in a clean table with one header row.
  • App updated and signed in with the right account.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports