The logs and history Copilot in Excel leaves behind are actually pretty detailed. You can usually see what you asked, how it responded, and in many cases the steps it took to get there.
The problem is that none of this is easy to keep track of over time. It lives in the chat, it gets overwritten, and once you move on or start a new conversation, it becomes hard to piece together what happened or why something was built a certain way.
What I wanted was a way to keep that history with the workbook itself.
What has been working well is a simple change log sheet that lives inside the file. It tracks the prompt, what Copilot did, where the output went, and any notes or assumptions along the way. It is nothing fancy, but it makes the work much easier to follow and revisit later. You can even have Copilot help maintain the log as you go, which keeps it from becoming extra overhead.
I recorded a quick walkthrough showing how this works in practice. You can also download the exercise files, including a sample dataset and a prompt guide, if you want to try it yourself. The full video walkthrough is embedded below as well.
If your team is trying to get more auditable, reliable results from Copilot or other AI tools, feel free to reach out. This same idea works in other tools like ChatGPT or Claude too.