We're making changes to the Community, so you may have received some notifications - thanks for your patience and welcome back. 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 of issues with an Excel file shared on Dropbox among colleagues of mine.

Everyday, either a colleague or myself will be editing the worksheet and saving it in a Dropbox for further use from other colleagues or myself.

Every time there is a modification in the file, a new copy of the file will be saved on the date of the day to have backups. Every week, the folder including different copies of the file at different dates will cleared up so old copies will be placed in an archive and the most recent file will be kept in the folder for further use.

All the users are on Excel 2016 Mac version 16.10

 

We have been using the file for one year + and recently my colleague is having a pop-up window whenever she needs to open the file: 

"Name conflict

Name cannot be the same as a built-in name.

Old name: _FilterDatabase

New name: 'field where I can write'

"

I have tried to fix the issue by following the below steps that I thought could fix the issue or that I found on the net:

- Copied/pasted the entire content of each tab in the file in a complete new file

- Removed all filters

- Tried to create a new name and the problem is fixed until we re-open the file

- Tried to press 'cancel' on the 'Name conflict' pop-up window. Another pop-up window will show

"Alert 

We found a problem with some content in the 'filename.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."

I click 'Yes' and the Name conflict pop-up window shows up, I click 4 times on 'cancel' and finally the spreadsheet opens with

"Excel was able to open the file by repairing or removing the unreadable content" I then click Delete.

The file is usable UNTIL someone else saves a new version on top of it...

- Tried to send a copy of the file through email but the issue persists

 

Very disappointing issue and clearly avoids us to work properly.

Wish a Microsoft technician could help me with this issue which is extremely inconvenient.

 "

 

Following to this message, I have created a copy of the file in .xls format and it is working without issue. However, I am willing to use .xlsx format as we used to.

 

Thank you in advance, regards,

Loïc

Edit
Restore
Share
Sharing
Sync
  • 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

  • Rich's avatar
    Rich
    Icon for Super User II rankSuper User II
    7 years ago

    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's avatar
      Sanchez
      Icon for Dropbox Staff rankDropbox Staff
      7 years ago
      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
      • LoicMonteil's avatar
        LoicMonteil
        Helpful | Level 5
        7 years ago

        Thank you for your inputs.

        Will contact back MS and will let you know.

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!