Automatically manage status of report

Question

I work with Excel for financial reporting, and it would be really helpful if Excel had a built-in way to mark a reporting period as “Closed” and automatically prevent changes to all data belonging to that period. For example, once March is finalized, Excel could automatically treat the March columns or rows as read-only, while April remains editable. Ideally, this could work without manually selecting cells, locking them, and protecting the worksheet each time. This would probably only be useful for a small group of Finance and Accounting users, but it could make period-end reporting much easier to manage.

Answer 1

Dear Doki Lewis,

At the moment, Excel’s documented protection options require users to define which cells or ranges are locked and then enable worksheet protection. There is no built-in reporting-period status that automatically locks the corresponding data based on a month being closed. Worksheet protection is mainly intended to prevent changes to locked cells, rather than to manage a financial close workflow automatically.

Here are some references:

• Lock cells to protect them in Excel | Microsoft Support
• Protect a worksheet | Microsoft Support

To ensure this feature is captured by the engineering team, I recommend submitting feedback. Microsoft places a strong emphasis on customer experience, and all feedback shared by users is taken seriously. Every comment matters, and product teams actively review customer input to help guide future decisions and improvements.

That said, as a Microsoft Q&A forum moderator, I am not involved in product design decisions and don’t have visibility into or influence over the product development roadmap. While I understand this may not be the outcome you were hoping for, please know that your feedback is both acknowledged and valued.

To ensure your request reaches the appropriate engineering team, I highly recommend submitting your idea through Microsoft Ideas · Community, which is the official feedback channel reviewed by Microsoft’s engineering and product teams. If multiple customers raise the same idea, it may increase the likelihood of consideration for future updates.

How to submit your feedback:

1. Visit Microsoft Ideas · Community
2. Select Send Feedback
3. Share your idea and describe how it would improve your experience

Once submitted, your feedback will be reviewed by the relevant engineering teams and may be considered for inclusion in future product enhancements.

Please rest assured that you’re not alone in requesting this type of functionality. I’ll continue to monitor related discussions, and if any updates or announcements are made regarding this feature, I’ll be happy to share them with the community.

In addition, you can also raise a feedback directly from within Excel: Go to Excel > File > Feedback > Make a suggestion

Thank you for your understanding, patience, and for taking the time to help improve Microsoft products. If you have any further questions or need clarification, feel free to reach out.