We are aware of the issue with the badge emails resending to everyone, we apologise for the inconvenience - learn more here.
Forum Discussion
LoicMonteil
7 years agoHelpful | Level 5
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 ...
- 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
Rich
Super User II
It's funny that Miscrosoft sent you to Dropbox for this as it's quite obviously a Miscrosoft issue, and has nothing to do with Dropbox. Just searching Google for Name cannot be the same as a built-in name and you'll find many topics that discuss the issue and explain why it's happening. The one below is a good start, but I'd suggest you perform the same search and read the rest as well.
Sanchez
7 years agoDropbox Staff
Hey LoicMonteil, welcome to our forum!
To be honest, I’m surprised that the MS guys weren’t able to assist, as these errors seem to be coming from their app, and I’m sorry to say, that it doesn’t sound like it’s an issue caused on our end.
If only one of your colleagues is having the issue, then I would take a closer look at her computer. Check for any recent changes like operating system or application updates, software additions or changes, etc.
The way you’ve described the error message, it sounds like there may be some content in the excel file itself that is causing these issues.
Another thing that’s catching my eye is the fact that you’re clicking on Cancel four times, to get to open the file. What is the other option here? Why are you clicking Cancel instead of the other option? You may be skipping a crucial step here.
You also mention that the file works fine in .xls format. If this is the case, it may just have to be that you keep it in this older format.
Cheers
- LoicMonteil7 years agoHelpful | Level 5
Thank you for your inputs.
Will contact back MS and will let you know.
- LoicMonteil7 years agoHelpful | Level 5
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
- Sanchez7 years agoDropbox StaffHey LoicMonteil,I’m glad that you figured this out! Thanks for sharing your solution with us here.Cheers :sunglasses:
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!