A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
so it seems to be an issue directly with the ARM based version of excel and the application itself which I cannot understand.
Yes, that is most likely.
.
Windows, and Office running on ARM is still in development. So it is not surprising (to me) when it doesn't work on an obscure feature. Or even a commonly used one.
.
Submit a Feedback to MS describing the problem.
Feedback Hub
The “Answers” forum / community is “staffed” mostly by users like yourself, unpaid volunteers. This forum is intended more for “How to do something in application A” type questions. We sometimes can provide work-arounds for problems, but we can’t do anything about underlying problem. If the forum can’t solve your question you need to talk directly to MS, you need to submit a “Feedback” to MS.
.
For a couple of years now MS has had a "feedback" process that allows users submit bug reports / problems, suggestions and new feature requests directly to MS developers and managers. You can submit feedbacks from within many MS apps, or you can use the Win10 “Feedback Hub” app. This article describes the different ways you can submit Feedback to MS:
https://answers.microsoft.com/en-us/msoffice/forum/all/microsoft-feedback-process/6f850368-8c86-481d-a207-d95b265c4be4
.
There is also a new web based “Feedback Portal” in development. It is still labelled “Preview”. It provides functionality similar to the feedback hub. Access to feedbacks submitted in 34 categories.
https://feedbackportal.microsoft.com/feedback/
.
As users we are unpaid quality control testers, we identify bugs, they pick which feedbacks they will work on, and when they will release them, for testing by Insiders and to general public.
.
But don't "expect" anything like feedback about your feedback back from MS.
.
MS will make fixes and changes on their own schedule.
.
They will not provide much, if any, advance notice of what they are working on and/or when it will be released.
.
Hint : get a “share” link to your feedback (may take a couple of minutes to process the initial submission of the feedback) and post the link back to this question. That way if someone finds this question they will be able to link directly to your feedback so they can vote for it and add their comments. The more feedback on a subject, the more likely it is to be acted on.
i.e.
"Feedback" suggesting that they create a "Support / Support" category in the feedback app to collect complaints about poor service in MS Support: https://aka.ms/AAdyeq0
.