You might see that the Dropbox Community team have been busy working on some major updates to the Community itself! So, here is some info on what’s changed, what’s staying the same and what you can expect from the Dropbox Community overall.
Forum Discussion
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 ...
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
Super User IIIt'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
Dropbox Staff
Dropbox StaffThank you for your inputs.
Will contact back MS and will let you know.
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
- Sanchez
