Data and spreadsheets
Write notes for someone inheriting a spreadsheet
A new owner needs to know what the workbook is for, where data enters, which cells calculate, how it gets refreshed and who maintains it. Write the notes by walking through the file as a stranger would, and record every step that currently lives only in your memory.
A text to start with
I am handing over a spreadsheet called [file name] that [what it is used for]. Data comes in from [source] on the [sheet name] sheet. Calculations live on [sheets or ranges]. I update it by [steps I currently do]. Draft handoff notes for a new owner. List every manual step in order and flag anything I described vaguely. Ask me about gaps instead of filling them in.
Example request. Change the details to fit your situation.Spreadsheet handoff sheet
File name and location of master copy: [ ] Purpose, in one sentence: [ ] Who uses the results: [ ] Input location (sheet and range): [ ] Source of the input data: [ ] How often it changes: [ ] Formula area (sheets and ranges): [ ] Cells that are typed values, not formulas: [ ] Hidden sheets, filters or links to other files: [ ] Refresh step 1: [ ] Refresh step 2: [ ] Refresh step 3: [ ] (Add more steps as needed.) Assumptions a reader would not see: [ ] Current owner and backup: [ ] Questions the new owner asked, with answers: [ ]
Steps that hide in plain sight
Most handoff failures come from habits the previous owner stopped noticing. Look for values typed over formulas, hidden sheets or columns, filters left on, and files that must be saved or exported in a particular order. Check for numbers pasted from another system on a schedule that exists only in someone's head. Named ranges, links to other files and settings such as manual recalculation also go unmentioned. Notes that say "update as needed" or "adjust the rate" without naming the cell are incomplete. The test is whether someone could refresh the file using only the notes.
Ask another agent to check the result
Read these handoff notes as someone who has never opened the workbook. List every manual step, assumption or setting that the notes imply but do not state, such as typed-over cells, hidden sheets or external links. Do not guess. Mark each one as a question for the owner, naming the sheet or range it concerns.
Test the notes with a real refresh
Ask the new owner, or a colleague who has not seen the file, to follow the notes and perform one refresh while you watch without helping. Write down each question they ask and add the answer to the notes. Record where the master copy lives and who may edit it. Set a date to revisit the notes after the first live use.