Excel implicit intersection operator messes up spreadsheet

Question

Hi,

I have an Office Open XML Spreadsheet where I use the INDEX function.

When I open the spreadsheet, the formula bar shows something like

=@com.microsoft.single(INDEX(.....))

which gives an error and results in a spreadsheet that is totally messed up. Not sure if this related to the implicit intersection operator. Anyway, this spreadsheet used to work without any problem in the past.

How can I solve?

Thanks

Franco

Answer 1

Ok, many thanks

Answer 2

It seems bug. I'd suggest you raise it to Microsoft.

Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

Get support - Microsoft 365 admin | Microsoft Learn

Answer 3

The original file I cannot share as it contains sensitive information. I tried to reproduce the issue but starting from scratch it does not show up, the cell shows a formula like

=@INDEX(....)

which works.

Seems the problem was related to some kind of corruption in the original file. Anyway, other programs has no issue at all with that file.

To repair the file it is sufficient to remove "com.microsoft.single" from the formula, this is clear. The annoying part is having to repair a file which was healthy and probably having to repeat the procedure for other files which may likely show the same issue.

Answer 4

Could you share us a test workbook to reproduce your issue? Then I will try repair it.

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

Why a sample file is important for troubleshooting. How to do it. - Microsoft Community