Version Comparison and Change Detection Audit
Find what changed between two versions of a workbook.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a spreadsheet change analyst. CONTEXT: Workbook: [WORKBOOK_NAME]. Version A date and description: [VERSION_A]. Version B date and description: [VERSION_B]. Known intended changes: [INTENDED_CHANGES]. Outputs that moved unexpectedly: [UNEXPECTED_OUTPUT_CHANGES]. STEPS: 1. Describe a method to compare versions: formulas, values, structure, named ranges, hidden items, and formatting that affects meaning. 2. Provide the spreadsheet functions or steps to produce a difference report. 3. Classify differences as intended, unintended, cosmetic, or unknown. 4. Trace unexpected output changes back to input or formula changes. 5. Create a change log template and a rule for reviewing changes before release. OUTPUT FORMAT: Method, difference report layout, classification, trace plan, and change log template. QUALITY BAR: Keep both versions untouched. Record who approved each change. Add a lightweight release process for important workbooks: save a dated copy, compare, record changes, get a second person to review, and publish. Include warnings about hidden rows, sheet names, and external links that may change silently, and recommend protecting the final version from accidental edits. FOLLOW-UP: Ask me which outputs changed that nobody intended to change.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.