Ravindra BagaleCourses & study guides मराठी Track your progress

14. Protection, Sharing and Printing

14.9 Sharing and Co-authoring

By Last updated:

Co-authoring (एकाच वेळी एकत्र संपादन) lets several people edit the same workbook at the same time. It needs the file to be saved in OneDrive or SharePoint (Microsoft 365).

Steps in Excel

  1. Save to OneDrive/SharePoint: File › Save As › OneDrive – YourCompany. The AutoSave switch (top-left) turns On.
  2. Click Share (top-right) › type e-mail addresses (e.g. shraddha@example.com) › choose Can edit or Can view › Send. Or Copy link and set who the link works for (may vary by organisation settings).
  3. When others open it, their names/initials appear at the top right and coloured cell borders show where each person is working.
  4. Use Sheet View (View › Sheet View › New) so your filter/sort doesn't disturb others (Microsoft 365).
  5. Features that block co-authoring in some versions: the old Shared Workbook feature, files saved in older formats (.xls). Save as .xlsx/.xlsm. (Macros do not run in Excel for the web.)

Worked example. Daily_Targets.xlsx in the team SharePoint: Ravindra Bagale (Pune) and Shahrukh (Nagpur) type their targets at the same time; each sees the other's changes within seconds; AutoSave keeps one copy – no more Targets_final_v3_new.xlsx in e-mails.

Ravindra Bagale's Tip

Many students e-mail the same file to 5 people and then sit combining 5 different versions. Keep the file on OneDrive/SharePoint and share a link – everyone will work on the same file. When sharing the link, always check whether it is "Can view" or "Can edit".

Worked example — sharing and co authoring

Why

Aarti Kulkarni in Pune and Oliver Bennett abroad both need a clear, repeatable way to use sharing and co authoring on a BrightLedger Finance sheet without breaking totals.

What

Sharing And Co Authoring is the Excel idea this page teaches. We will walk one tiny example end to end.

How

  1. Open a blank sheet. In A1 type a short label for sharing and co authoring.
  2. Enter a small made-up value for Aarti Kulkarni using £ where money appears.
  3. Add a second value for Oliver Bennett using € so you see mixed currencies stay numeric.
  4. Apply the method from this lesson step by step (menu or formula as shown above).
  5. Check the result still works inside SUM or a simple check cell.

Formula / action

Follow the formula or ribbon steps shown in this lesson (keep values numeric).
Result: The demo cell shows the expected result for BrightLedger Finance's sample row.
Meaning: Once sharing and co authoring is correct on one row, copy the same pattern down the column.

Practice tasks (10+)

Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.

1. Rebuild the smallest example of sharing and co authoring on a blank sheet for Summit Schools.

Hint: Use only the steps on this page. Keep numbers numeric.

2. Change one input for Meera Joshi and confirm the result updates.

Hint: If the result is stuck, check absolute vs relative references.

3. Repeat the same steps with a £ or € value for Yuki Tanaka.

Hint: Formatting must not break SUM.

4. Write the result meaning in one plain sentence next to the cell.

Hint: Imagine explaining it to a new joiners.

5. Add a second row and fill the method down.

Hint: Double-click the fill handle if the pattern is consistent.

6. Break the example on purpose, then fix it using this lesson.

Hint: Common break: text instead of a number.

7. Apply sharing and co authoring to a 5-row made-up Summit Schools table.

Hint: Keep column headers clear.

8. Check your answer with a simple total or COUNT.

Hint: A wrong total usually means a format or key mismatch.

9. Swap ₹ and $ on one column and re-check totals.

Hint: Stored values stay the same; only the display changes.

10. List two mistakes beginners make with sharing and co authoring.

Hint: Look back at the tip box on this page.

11. Teach the steps out loud in under one minute.

Hint: Why → What → How.

12. Save the sheet as SummitSchoo_practice.xlsx.

Hint: Use a clear file name for class.

Loading practice tasks...

  1. Input cells to unlock (Easy): How many cells are in the Monthly target column?
  2. Total target (Easy): Add up the Monthly target column.
  3. Total actual (Easy): Add up the Actual column.
  4. Highest target (Easy): What is the largest value in the Monthly target column?
  5. Overall achievement (Medium): Divide the total Actual by the total Monthly target. Round to 3 decimals.
  6. Cities below target (Medium): How many cities have a Gap below 0?
  7. Manager for a city (Medium): Find the Manager for City "Berlin".
  8. Pages to print (Medium): If one page holds 4 data rows, how many pages do the rows need?
  9. Gap for the first city (Medium): For the first row, find Actual minus Monthly target.
  10. Best performer (Hard): Which City has the largest Actual?
  11. Status for the first city (Hard): For the first row, return "Hit" if Actual is at least Monthly target, else "Miss".
  12. Total shortfall (Hard): Add up the Gap column only where it is below 0, and show it as a positive number.

See all practice tasks in the Task Hub →

Quick revision cards

Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.

Revision card 1: What is Sharing And Co Authoring?
Card 1: What is Sharing And Co Authoring? · Download PNG
Revision card 2: Tiny example — Sharing And Co Authoring
Card 2: Tiny example — Sharing And Co Authoring · Download PNG
Revision card 3: Checklist — Sharing And Co Authoring
Card 3: Checklist — Sharing And Co Authoring · Download PNG