![]() so the other parties insurance company is saying it is his word against mine and they wont pay my bills or replace my motorcycle. This "feature" is driving me nuts, and looking at this thread, it looks like it has been there for years, with nothing being done by Microsoft. I was involved in a motorcycle accident and I have a police report and a witness who says the other driver who hit me ran a red light, but now the other driver is saying he has a witness who is claiming i ran a red light. 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. Go beyond dictionary lookups with Word of the Day, facts and observations on language, lookup trends, and wordplay from the editors at Merriam-Webster Dictionary. Our pronunciation help, synonyms, usage and grammar tips set the standard. It makes the macro automation un-useable since it is not possible within the macro to detect that the file is some old version. No other dictionary matches M-Ws accuracy and scholarship in defining word meanings. 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 |