Forum Discussion

Copper Contributor

Jun 16, 2022

CSE formula does not calculate correctly using application.calculateFull (or other variations)

Hello, Excel version - Office 365. In the attached workbook, I have an array formula that is entered as CSE (Ctrl + Shift + Enter). It is a relatively simple formula that is a combination of f...

Calculate Error_Test psw.xlsm16 KB

excel

Formulas and Functions

office 365

papa_austin

Copper Contributor

Jun 17, 2022

Thank you!

This appears to be a bug with Excel (application.calculate causes an unexpected error).

I'm interested in finding out if this is a known bug. Like has MS reported this before? Or any blogs?
It matters because my workplace has many examples like this. I would like to know if I need to alert my co-workers of this bug. It would be helpful in my communication if this was a known bug that is documented.

If not, what would be a way to get hold of MS Excel team's attention on this?

amit_bhola

Iron Contributor

Jun 17, 2022

papa_austin , not sure if this behavior should be labelled as a bug . Sure it is not as per user expectation because this behavior of CSE formulas is different from non CSE formulas. But then, manual (calculation) mode and CSE formulas too are quite unique scenarios in themselves and have some / may have some lesser known unique behaviors associated with them, like this one, which are not so well documented.

As for your query, sorry I'm not aware of any official documentation or blog which lists the issue at hand.

Below portal may be of some help to share feedback to MS

https://feedbackportal.microsoft.com/feedback/forum/c23f3b77-f01b-ec11-b6e7-0022481f8472