Curious about A, B, C, and D drives? Learn what they mean and how to use them effectively with Dropbox in this handy guide! - check it out now!
Forum Discussion
Solved
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
Thank 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
Dropbox Staff
