Windows 10: Excel File Lock Changes Between Users Whilst in Use

Hi,

I've come across a strange issue with a few Excel files on our file server.

A user (user1) opens an .xlsx file, works on the file and keeps it open for approx 1hr.
Another user (user2) opens the same file, and isn't notified that the file is locked and can only be viewed in 'read-only' mode.

User2 modifies the file, save the file and carries on working, yet User1 modifies the file, saves it and is presented with the message that someone else is accessing the file and no further changes can be made.

So, user 1 should be have 'lock' rights to the file, but for some reason user2 'steals' the rights from user1 and takes temporary ownership.

Has anyone come across the behaviour before?

Both users have Office 365 (2016/2019), running Windows 10, files hosted on Windows Server platform.

Thanks

:)

 

Excel changes the owner of file during save


When Excel saves my workbook file, it changes the NTFS ownership of the file to the user account that is using Excel. I need it to allow the data to be changed within the workbook, but not change the file's ownership. Any ideas?

• Windows 10 Pro ... clean recent install ... all updates are current
• Office 2010 (Excel) ... clean recent install ... all updates are current
• The original owner of Excel file is in the Administrator group
• Excel user is not in the Administrator group
• Excel user has the following inherited permissions to the file, through a group, inherited down from the folder in which it resides:

Modify
Read and execute
Read
Write

• Excel user does not have the following permissions. I checked this in Properties using the "Effective Access" feature:

Full Control
Change permissions
Take ownership

The only unusual thing is the Excel file came from an XP machine. I don't see how that would affect anything but ...

Any help with this would be greatly appreciated ... I tried everything I can think of, and have searched this forum and the internet without success.

Thanks

 

Excel changes the owner of file during save


I just duplicated the problem with a brand new Excel file that had nothing to do with the old XP machine ...

• Signed in as the original owner who is in the administrator group
• Created a new Excel file in the same folder as above
• Edited the file with Excel as the original owner ... saved
• Checked ownership and permissions. Everything looks OK, including the inherited permissions from the folder
• Signed off
• Signed on as a second user who is not in the Administrator group
• Edited the the file with Excel as the second user ... saved the file with changes
• Signed off
• Signed on as the original owner
• Checked ownership and permissions. The ownership of the file has changed to the second user.

The original and second users are the exact same users described in the post above. Uggghhh ...

Clueless in Houston ...

 

Excel files change to pdf on receipt

The previous fix worked for adobe files to change them from internet explorer to pdf. have the same problem with excel files as they change to pdf on receipt. I cannot use same procedure to change excel files from adobe back to excel files as the excel program
does not appear in the list after clicking change and more apps. Word appears but not excel.

How do I fix this.

Don XU