We are aware of the issue with the badge emails resending to everyone, we apologise for the inconvenience - learn more here. 

Forum Discussion

LoicMonteil's avatar
LoicMonteil
Helpful | Level 5
7 years ago

Name conflict on shared Excel worksheet

Hello there, The below email has been sent to Microsoft 2 days ago and they advised to contact Dropbox. Hope Dropbox experts are able to understand the cause of the issue.     "Having a couple ...
  • LoicMonteil's avatar
    LoicMonteil
    7 years ago

    Hello there,

    Finally solved the issue!

     

    Here is how to solve the issue:

     

    - Open the file by creating a new name (?). My version works on my computer, it's on a colleague's one that it shows the name conflict issue

    - Press fn + option + F11 on Mac OR Alt + F11 on Windows

    - Right click on the tab you are having issues with in the list on the left

    - Click on 'display the code' (using French version so not sure what the English version would be)

    - Paste the code below in the window that appears in the center

    - Run the code by clicking on the run button

    - A window will pop out, click delete for all issues

    - Once done close the window and save the file

    - Close the file and reopen

    Code:

    Sub DELRNG()

      Dim rNme As Name

      On Error Resume Next

      For Each rNme In ActiveWorkbook.Names

        If (MsgBox("Delete the name? " & rNme.Name, vbYesNo) = vbYes) Then

          rNme.Delete

        End If

      Next

      On Error GoTo 0

    End Sub

     

    Hope it helps solving the problem for others.

    Regards,

    Loïc

About Delete, edit, and organize

Solve issues with deleting, editing, and organizing files and folders in your Dropbox account with support from the Dropbox Community.

Need more support

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X or Facebook.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!