![]() ![]() ![]() ![]() ![]() 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). 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. 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 |