Forum

Hi Lea, Hard to say why. Try opening that link in a different browser in private mode, make sure that link is accessible without errors. Use a simpl...

Hi Jean, After you download the files, extract the files from that archive into a normal folder: If you open the zip archive with Windows Explorer, y...

Hi Sammie, Please upload a sample file, we cannot see what you did in that file to be able to help. Thanks

Hi Shanny, Can you please upload an example of how your data is structured and your expected result? Hard to provide an answer without seeing the fi...

Hi Graham, Is it just one query you mentioned or there are more objects to refresh? Instead of RefreshAll, try referencing the object: ThisWo...

Thank you for feedback Chris, nice to hear you managed to find a way out.

That was my only suggestion unfortunately, never hit this problem

Hi Chris, Can you try again but with another browser set as default? If Edge is your default browser, change to Chrome or any other.

Short Answer: No, if you manually type values in Index column D. Instead, you should type these values in a manual table, where you should type the...

Hi Marco, This article should clear most issues: Signing macros requires replacing the signature from time to time, if you have lots of files ...

Worth to mention something about OneDrive: OneDrive is not just on your local computer, those files are in cloud as well. While you cannot refre...

As said, filtering out temp file works only outside OneDrive.

Hi Matthias, There's little control of the data model from VBA, mostly because data modelling is not a simple process. If you go to Object Brows...

Hi Farshad, List.Accumulate is not necessary in this scenario. However, the query looks like this: let Source = List.Accumulate({Table1,T...

What other types you have in mind? Should be easy to add new types in the list you mentioned, with any types you need.