3/17/2024 0 Comments Why doesn t my word document openThis 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. The result is that the automation becomes unreliable - which completely defeats its purpose. It makes the macro automation un-useable since it is not possible within the macro to detect that the file is some old version. I 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. This is not satisfactory behaviour, and there should at least be a way to configure your way around it - e.g.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |