A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi @Chris Cooke,
Welcome to Microsoft Q&A forum.
Thank you for reaching out and for outlining the behavior so clearly.
I completely understand how inconvenient this can be, and how important this functionality is for your workflow. To report this issue directly to Microsoft, I recommend submitting feedback via the Excel app > Help > Feedback > Report a problem or via the Microsoft 365 Feedback Hub > send feedback.
Note: As community moderators, we kindly ask for your understanding that our access to internal development details is limited. Our primary role is to guide users toward the appropriate resources and support channels. While we may not have influence product design decisions and have limited access to internal development details, we’ll continue doing our best to support you within the scope of our responsibilities.
For now, I highly recommend upvoting this answer as well. That way, other users who encounter the same question will see the clarification, and more of them may report similar problem, helping to bring attention to the request. The more reports the team receives, especially from business users, the faster issues like this can be prioritized and resolved as soon as possible.
I know this is not the experience you expected, and I want to thank you for your patience while the team works on improvements.
Thank you for your kindness and contributions to the forum.