Well why not just have a setting to ignore the cache and grab the "server" version every time? After all, I opened it directly "from the server", so, yes, that is the file that I want! (I've tried Options > Save > Delete files from cache when closing Excel, and I have deleted the Microsoft Office Cache, but that doesn't work). What might be the reason (or is it by design) that if we open Excel Files from our on-premises SharePoint 2019 we get this waring ribbon saying 'READ-ONLY We opened this workbook read-only from the server -> Edit Workbook', while this is not true for a Word or Powerpoint documemnt form the same location. This behaviour is clearly a deliberately designed FEATURE, since Excel isn't throwing an unhandled error - it knows there is a newer file "on the server" (Sharepoint Online), and shows a message asking the user to refresh. As for opening the Word files that are Read-Only, open the file, go to: Tool/Options/Security Tab, Look to see if the 'Read-Only Recommended' box is checked. The result is that the automation becomes unreliable - which completely defeats its purpose. Here are some scenarios where a file opens read-only and some steps you can take to change that. In some cases, this is for added security, such as when you are opening files from the internet, and other times, it can be due to a setting that can be changed. It makes the macro automation un-useable since it is not possible within the macro to detect that the file is some old version. You may find that when you are opening files, they open as read-only. #Why do my microsoft word documents open as read only updateI have created an Excel macro for one of my customers which updates a series of other Excel files in Sharepoint (directly from Sharepoint NOT from a synch'd OneDrive folder) - but, apparently randomly, the Excel App sometimes chooses to open an old version of the modified file, and fails to update the actual file in Sharepoint. a setting in Excel/Word to ALWAYS get the latest version from Sharepoint. However, the file only opens in Microsoft Word if that file type is associated with Microsoft Word. In some cases, you can double-click a file to open it in Microsoft Word. This is not satisfactory behaviour, and there should at least be a way to configure your way around it - e.g. To open any of these files in Microsoft Word, including files created and saved in Word, you can use any of the options below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |