excel cannot save changes made by another user

One of the drives failed. Please let us know if you would like further assistance. Hi All,This could be a long story but I'm shortening it for your sake and mine. back the one at 9:28am. Vendor gave us a computer to run a laboratory instrument a few years ago. I have to assume your users are not accessing the Excel files simultaneously? thumb_up thumb_down OP steveh7 pimiento Right click to open the context menu and select Show Changes. Working server 2008 R2 win 7 pro client. Although Excel has an AutoSave (how to turn on Excel AutoSave) function that will automatically store your workbook as you edit it, it doesn't work in this case where you've saved the files on one's own initiative. OneDrive Cannot Save Changes - Openpyxl : r/learnpython - Reddit Sign up for notifications from Insider! It was noted in another forum that this issue occurred f the user opens the file, the document creates a temp file in the same directory as the original file, normally it deletes automatically when closing the document. Click "Add Files" to select corrupted documents. 2. Git (2) My instinct is that this is a network problem but I don't know. By clicking Sign up, you agree to receive marketing emails from Insider Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. In our case, I am certain that the issue is not being caused by user error. Apr 23rd, 2014 at 8:52 AM. Required fields are marked *, Click to share on LinkedIn (Opens in new window), Click to share on Reddit (Opens in new window), Click to share on WhatsApp (Opens in new window), Click to share on Twitter (Opens in new window), Click to email a link to a friend (Opens in new window). If still issue persists, please provide the following: 1. ? Microsoft Office (4) Changes made in excel document are not saved. Select Range orSheet to filter the changes shown, and then do the following: To show a rangeorcells changes,select Range andenter the range or cell in the text box. I did not see it mentioned in the Office 2010 SP2release notes. Select "Save All" to save all the repaired files. 4.Type QFE_Saskatchewan for the name, and then press ENTER. and its like they save some data and the next day that data is not visible.,( or not saved). Our workplace has hundreds of locations where this file can be opened from, so it is laborious to figure that out. But, the problem is that the one user cannot see changes made to any Excel document by others. Up until yesterday we thought we had put this problem behind us. Even in a shared workbook, the next user that opens up the file has to agree to the changes made. explore and Flashback: July 28, 1981: IBMs First Desktop Computer (Read more HERE.) When the file is checked out the other users can't edit. In the tutorial I will go over the following error message in Excel: "file may have been changed by another user since you last saved it. To be more precise, the Excel file seems to be reverting back to an earlier version (we have major versioning enabled). Step 3. Azure DevOps (3) But I mean these were scholars that put this together," DeSantis said. Wait for the process to finish and startExcel and see if you can save it. When the antivirus software is running and protecting your computer, it may interrupt the Excel saving process and stop you from keeping formatting or data changes. Did all users have the same permission to access the folder? Then restart Excel. In that case, what do you want to do?" This error message can arise due to various problems and therefore it is difficult to troubleshoot. If you have found another solution, please leave a comment for other users. In the Open dialog box, choose the Excel file that cannot be saved. Is the Excel file in the same PC with Office? Recovered Conflicts If they're not seeing this pop-up, they are likely not accessing the same file. How to Unlock Excel file locked for editing by "Another User" It seems the temporary file did not prevent users from opening/editing the Excel file, however it did prevent the actual user name from showing in the locked for editing dialog box. I'm going to play with that a bit. .button_box_20201112 .article_button_20201112.blue:hover{background: #089b4d;}. here to learn more. The workbook is not shared, as it is not an issue for them to take turns working in the file. also in windows explorer, under Date Modified, it doesn't show the latest date that it was updated by the other user example 8/7/2013 4:54 PM. EaseUS Data Recovery Wizard is the best we have seen. Florida Gov. They have typically blamed my workbooks for any issues as they contain 'too many formulas.' My annual subscription is up to date. Step 4. This fix does work. reduce the number of messages/pop-ups to 0. get rid of the macro (maybe Power Query can replace it) or get the macro digitally signed (this would remove both messages/warnings from the yellow bar. Option 1: Save the workbook by using a new file name Option 2: Move the original worksheets to a new workbook Option 3: Save the file as a different Excel file type Option 4: Try to save the workbook to another location Option 5: Try to save a new workbook to the original location Option 6: Try to save the workbook in safe mode More information Click Merge copies of a Shared Workbook - Microsoft Support thanks for help. View all posts by Bas Wijdenes, ( THE FILE BOOKING REPORT 2019 XLSX MAY HAVE BEEN CHANGED BY ANOTHER USER SINCE YOU LAST SAVED IT IN THAT CASE WHAT DO YOU WANT TO DO ), WHO IS THIS PROBLEM TO EXCEL The interim solution has been to prohibit everyone from viewing the document, which is not ideal. In my spare time I write about interesting stuff that I encounter during my work. Once your problem is solved, reply to the answer (s) saying Solution Verified to close the thread. For example, check folder permission, disable add-ins, extend the disk space, turn off antivirus software, as well as repair corrupted Excel files with a file repair tool. One of the drives failed. Click "Yes" to open Excel in safe mode. Collaborate on Excel workbooks at the same time with co-authoring Watch Newsmax LIVE for the latest news and analysis on today's top stories, right here on Facebook. Allowing users to edit but not save changes to Excel files on OneDrive Click "File" > "Options" > "Add-ins". If possible move the database in the same file. Chanclaw The workbook is not shared, as it is not an issue for them to take turns working in the file. the main thing here is that everything was set up and configured and worked great, then they added 'Auth-Air' devices, and after a bit, this started happening. if it has already been opened by another user before them. We have some users who have access to a The law was intended to push back against the supposed teaching of critical race theory examining how America's history of racism and discrimination continues to impact the country today in public schools. My Way (13) Click "File" at the top left corner, then, click "Open". "If you have any questions about it just ask the Department of Education. "your file wasn't updated because we cannot merge changes made by It contained 2 HDDs in a Raid 1 array. But with your issue the user might have no permission to One of the drives failed. forum to share, explore and It is just a limitation of the product. Click If you're looking at a view of the library on another page, you may have to click the title of the library first. Show Changes in Excel lets you see exactly what edits were made to your workbooks, so you can confidently allow others to collaborate on your work. In advanceif I can recommend you, add a file (without sensitive data) to your project. excel file doesn't get updated in a shared drive - Spiceworks Community | Newsmax, John Bachman For more protection options, click File > Protect . The notification lets you stay in control when you want to refresh the list and not be distracted when reviewing changes. After 10+ hours of troubleshooting and talking to numerous Office 365 support agents, our best diagnosis was that the issue was caused by the SharePoint Online service degradation that was occurring at the time - it had something to do with 'public-facing SharePoint'. My blog uses cookies to give you the most relevant information. Restrict changes in Excel. I'm having the same issue as you. I tried the open and 'save-as', sometimes that works. Then Click the "Execute Task" button and click "Apply" to keep all the changes. Fix 4. That should rule out a bad office patch too. Choose "File Repair" to repair corrupted Office documents, including Word, Excel, PDF, and others. Shared excel file updates not visible to all users - Spiceworks Community Lets fix File may have been changed by another user since last saved it. As far as I know if the user opens the file, the document creates a temp file in the same directory as the original file, normally it deletes automatically when closing the document. PLSEAE SOLUTION TO EXCEL SITE. At the very beginning of problem-solving, you should first check whether your workbook is intact. Thus the document gets a temp file to lock the document. Your daily dose of tech news, in brief. Open the original Shared Workbook into which you want to merge changes. Microsoft has a repair utility to repair corrupted Office applications that may cause Excel not saving changes. Does anyone know if Microsoft has acknowledge this as a bug and if they are working on a patch? Uncheck all the add-ins in the list, and click "OK". How to fix it: Select Resolve. It affects their workday to know what these changes are.