Excel name conflict with _FilterDatabase when openSpreadsheet

Hi @Polyana 8891,

Verify if the Excel and OS are in the same language, this usually occurs when the language is different. 

we suggested to use all the references in a single language or modify their current work to a different name to resolve the issue. This issue is with the UI behavior in Excel itself. 

https://answers.microsoft.com/en-us/msoffice/forum/all/name-cannot-be-the-same-as-built-in-name/80972ecb-a4bc-45ac-9381-c4714c30ca1b

Thanks. 

Hi @ravi.pothana!

The language is the same. I forgot to mention that this message box only happens when the bot opens the excel file, if we open the file manually nothing happens.

I tried to check the defined names to see if there were any that could be renamed so it wouldn't happen again, but there is no defined name that could cause a conflict. So I thought maybe there could be some way around this with Automation Anywhere.

@Polyana 8891 

Check the following resource, probably is a issue related with undescore  in the name

https://support.microsoft.com/en-gb/office/why-am-i-seeing-the-name-conflict-dialog-box-in-excel-f9251985-dbde-4030-86d8-e90775e79952

HTH

Regards

Hello,
I have exactly the same problem. What I have also noticed is that the problem only occurs with the Excel Advanced addin. If I start Excel via "Open application" the error message does not appear. 
Is there already a solution to solve the problem? The suggested solutions from Microsoft are not working for me, as the problem only occurs when opening via the robot. So normal users do not get the message.

Regards

Hello, @kassnera!

Unfortunately I haven't found a definitive solution yet, none of the solutions presented worked for me. But something I've been doing that helps is taking the data from the database that opens with this message into a completely new database. Depending on the data, it takes a little work, but it solves the problem. But it is necessary to remember that if the base is manipulated a lot again, the problem will happen again.

I'm still looking for a definitive solution, but at the moment this is the most I can help!

I would like to share a information about this problem. I have this same issue with my bot that updates a spreadsheet.

About keeping the same language in AA and Excel, both of them was set with Portuguese, but it still was not working.

Just when I set AA and Excel with English language, so the bot works normally. Then here is the secret.

But I understand this is not a definitive soution, just a workaround and Automation support should provide a better resolution.

Bom dia galera, 

Tive exatamente o mesmo problema, e resolvi usando uma macro executada em VBA.

1. Abra seu arquivo de Excel manualmente.
2. Depois vá na aba Exibir e clique em gravar Macros, e clique em “ok” para iniciar.
3. Depois clique em qualquer célula e depois vá novamente para Macros e clique em parar gravação.
4. Depois vá para macros e clique em exibir macros e clique em Depurar.
5. Vai abrir automaticamente o VBA (Microsoft Visual Basics for Applications).
6. Selecione tudo que estiver digitado e apague.

7. Substitua pelo seguinte script:
   Sub Macro1()
   '
    Dim rNme As Name
    On Error Resume Next
    For Each rNme In ActiveWorkbook.Names
     rNme.Delete

     Next
     On Error GoTo 0
   End Sub

8. Depois execute ou dê F5.

9. Feche e salve seu arquivo Excel, e agora é só executar seu bot normalmente.

Abraços do Brasil.