The issue you're encountering with Excel not saving changes and the error message regarding merging changes typically arises from conflicts when multiple users are trying to edit a shared file simultaneously. Here are some steps you can take to resolve this issue:
- Check Permissions: Ensure that all users have the necessary permissions to edit the file in Dropbox. If someone only has read permissions, they won't be able to save changes.
- File Locking: When a file is opened for editing by one user, it may be locked for others. Make sure that the file is not being edited by someone else at the same time. You can check the file's status in Dropbox to see if it is currently open by another user.
- Save As a New File: If the supervisors are unable to save changes, they can try using the "Save As" function to save the file under a new name. This can sometimes bypass the merging issue.
- Use Excel Online: If possible, consider using Excel Online for collaborative editing. This can help avoid conflicts as it allows multiple users to edit the file simultaneously without the merging issue.
- Check for Updates: Ensure that the Excel app on the iPads is updated to the latest version. Sometimes, bugs in older versions can cause issues with file saving.
- Temporary Files: If the problem persists, check for any temporary files that may be causing conflicts. Sometimes, Excel creates temporary files that can interfere with saving.
- Antivirus Software: If antivirus software is running on the iPads, it may interfere with the saving process. Temporarily disabling it can help identify if it's causing the issue.
By following these steps, you should be able to troubleshoot and resolve the issue with saving changes in the shared Excel file.
References: