Spreadsheets

Two people, one Excel file: co-authoring on OneDrive

Set up one shared Excel expense file on OneDrive so two people can edit together, what AutoSave and presence markers mean, and what blocks co-authoring.

Editorial illustration for Two people, one Excel file: co-authoring on OneDrive

Yes, two people can edit the same Excel expense file at the same time, provided it is an .xlsx workbook saved in OneDrive and shared with edit permission. You both open it from the shared link, keep AutoSave switched on, and Excel merges your changes within seconds. This is called co-authoring, and it ends the habit of emailing "expenses_final_v3" back and forth.

How do we set the file up as a couple?

  1. Save the workbook into OneDrive (File, Save As, then your OneDrive folder). Check that the file extension is .xlsx; an older .xls file should be re-saved in the newer format first.
  2. Click Share at the top right, type your partner's email address, and set the permission to Can edit.
  3. Your partner opens the link in desktop Excel or in a browser. Either works for entering expenses.
  4. Both of you confirm that the AutoSave switch at the top left shows On. If it is Off, changes are not flowing to the shared copy.
  5. Do a two-minute test: each of you types a different amount in a different row and watches it appear on the other screen.

What do AutoSave and the coloured markers mean?

AutoSave writes each change to the OneDrive copy as you go, so there is no Ctrl+S routine. The flip side is that a mistake is saved as quickly as a correct entry. If a row is deleted by accident, use Undo straight away, or open File, Info, Version History to go back to an earlier copy.

When your partner is in the file, Excel shows their name or initials on the cell they have selected, in a colour different from yours, and their picture or initials appear near the top right. Treat a flagged cell as occupied. If their name is sitting on the cell you want, edit another row for a minute.

What happens if we both change the same cell?

Edits in different cells are simply combined. If you both change the very same cell, the save that reaches the file last is the one that stays, and Excel may ask which version to keep. The cure is to arrange the sheet so that clashes are rare.

Part of the fileSafer arrangement
Day-to-day entriesOne tab each, named for the two of you, so nobody types into the other's rows
Recurring billsAgree who owns society maintenance, electricity and broadband, and enter each only once
Summary tabFormulas add up both entry tabs; only one person edits this tab
Sorting and filteringSorting a table reorders rows for both of you, so sort a copy, or use a private sheet view if your Microsoft 365 version offers one
Month endUse File, Save a Copy and name it with the month before you tidy anything

Which features stop co-authoring from working?

  • The old Shared Workbook option from earlier Excel versions. If your file was made with it, switch it off and rely on OneDrive sharing instead.
  • A password on the file itself. If Excel says the workbook is locked or opens it read-only, remove the file password and manage who can open the file from the OneDrive sharing options.
  • Older file formats such as .xls, which should be saved as .xlsx.
  • Sheet protection. It does not break sharing, but locked cells will stop your partner editing them, which may or may not be what you intended.
  • Very old Excel versions, which may not show live changes. The browser version of Excel is a fallback.

Microsoft keeps its own list of features that limit co-authoring, and it changes with updates, so check the current list if Excel shows a warning you do not recognise.

What should we agree before the first month?

  • The same column order on both tabs: date, category, amount, paid by, note.
  • One date format, for example 05-Nov-2026, so month totals do not break.
  • A drop-down for categories, so "Grocery", "Groceries" and "Kirana" do not become three lines.
  • Who records cash spends, and by when in the week they are entered.
  • A fifteen-minute review on a fixed day, perhaps the first Sunday of the month.

When a shared sheet stops being enough

If the typing itself becomes the chore, SpendixAI takes bank and card statements as PDF, CSV or Excel files, lets you review the rows before saving, and keeps the transactions under the account you picked. It is one personal workspace rather than a joint tool, so many couples keep a small shared sheet for household items alongside it.

SPENDIXAI JOURNAL

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

Explore your reports