Forum Discussion
Sharepoint folder date problem
This is a bug in March issue and unfortunately also on the Service.
My organisation is on the six-month update cycle so if this started happening in March 18 then at least two updates since then haven't fixed it. I'm using Excel Power query but, it's the same issue. Thanks for this suggestion (export the sharepoint list data to Excel using the provided SP routine to do that). It looks like it will work for my purpose as a workaround. This should be fixed properly of course. Still as long as these more intelligent solutions keeping making things harder it keeps some of us in jobs :-)
Yes, I can confirm that this worked fine, and yes, I had to edit the url a little, I have since then been able to call the refresh from VBA, so, worked OK really. Would still be nice to be able to simply navigate to a file as used to be possible with fileshare (I know that if you edit the URL and add it to file explorer (this pc), whatever it's called now, you can do this, but that takes advanced planning).