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