Cant Unshare Excel Lfile Locked Try Again
Howdy DanFlak,
Thanks for using Microsoft products and posting in the community, I'yard glad to offer help.
According to your description, since the problem volition non arise in most cases, it is hard to find the root cause as nosotros can't steadily narrow down the problem.
I'd like to suggest y'all keep your Function suites up to engagement, and cheque whether all workbooks or i specific workbook have the trouble. Based on some enquiry, members constitute that sometime renaming or copying the problematic workbook can solve the trouble.
Sorry for non existence able to figure out the root cause straight, but I hope the above information tin requite you some guidance and help y'all a lilliputian, if there is whatsoever progress, delight experience gratuitous to post back, I'll proceed to assistance you lot.
Best Regards,
Arck
1 person found this reply helpful
·
Was this reply helpful?
Keeping the Office Suite up to date is not within my control. That's up to my IT department.
I am pretty certain they are on tiptop of it. However, when I brand some spreadsheets at home and re-create them to piece of work, I sometimes go a bulletin that at that place may exist some compatibility issues - my home system apparently is a decimal bespeak of a build alee of piece of work.
The files are produced very consistently. Information is imported, I look up buyers' names based on the office number, Put it all in a tabular array - copy the sheet to a new workbook, "united nations-table" the table into a range, share the workbook and relieve information technology. It'southward an automated process and it is done the aforementioned way every time.
Renaming the file is an choice. I've done this in the past. Then I have multiple copies of the workbook that I have to merge manually. There is likewise the affair of notifying all the team members of which workbook is the nearly current. Then there is the issue of my trying to figure out which workbooks have the near electric current comments for which buyers. It would be simpler to issue an unshared workbook for each buyer and write lawmaking to merge them at the finish of the day.
If I had my way, I'd exist doing this in a database and using Excel to report the data and not as a data entry mechanism.
Was this reply helpful?
Howdy DanFlak,
Thanks for the clarification, since the workbook made at dwelling house will have compatibility issues when opened in your visitor, if you saved the workbook as *.xlsx, your visitor's Excel may have an older version that could cause compatibility issues.
Because that Office updates are controlled by your organization, y'all tin endeavor to contact It and written report the current state of affairs, try to ask them to update Excel for the affected users to see if the effect tin can be stock-still.
If your It still doesn't let you to do that, in addition to renaming the workbook, you tin can attempt to manually copy the content of the problematic workbook to another newly created workbook to see the performance. In the meantime, y'all can go to File > Info > Audit workbook to check compatibility.
Best Regards,
Arck
Was this answer helpful?
I'm sorry about the confusion. The shared files are created on the work system.
My mention of the message was to indicate that while my work arrangement has a very current version of Office, information technology may non be the absolute latest. However, since this outcome goes back to Excel 2003, I don't think that this is the issue.
1 person found this answer helpful
·
Was this respond helpful?
We are finally doing it the right way. Our users are updating data in a database. Excel is pulling the data records and pointing out what records they should be looking at.
It is non what the users are used to doing, merely it'due south the right thing and they are getting used to it.
Was this reply helpful?
Source: https://answers.microsoft.com/en-us/msoffice/forum/all/shared-workbook-this-file-is-locked-try-the/d3316410-62e0-4b07-8b4e-15b913925d1c
0 Response to "Cant Unshare Excel Lfile Locked Try Again"
Post a Comment