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
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
