Our Finance team has password protected many of their files, as they contain salaries and other sensitive information. However, every time they open one of these files, AutoSave is disabled, and they have to constantly save over the top of the existing file (ie, they can't just hit Save). This is a complete nightmare for them, and they want to abandon SharePoint because of this. Obviously, we can't be the only organization that uses SharePoint and Excel together who happen to have passwords on the files.
Is removing the passwords the only way to stop this? They're wasting time and reckon that a 3-minute job now takes them half and hour because they're constantly having to go through the 'save as' dialog box everytime they make a change and want to save.