Last seen: Jul 3, 2025
Power Query does not work in excel online, only in excel desktop app unfortunately.
You are not providing the code you are using so it's hard to see what you are doing. Are you using .HTMLBody? If you use .Body instead of .HTMLBody...
Not without macros unfortunately.
If the same value is repeated in a column, don't use the Sum aggregation, use Min or Max or Average, each will show only one of those values.
Hi Robert, What kind of implementation you have in mind?
Can you please clarify what backward navigation means?
The macro names are not repeated, they are just prefixed with workbook name.
Where is the source of data for that Power Query from the file you are opening in Excel Online?
Hi Barbara, No code can run when you are editing cells, the timer cannot be used when you need to edit cells.
A link in html looks like this: <a href="https://www.site.com/">click here</a> "You can access the File here: "...
If you're saying that the folder is already synced to your computer, why don't you save on the local synced folder?
There might not be formulas to do that, it's much easier in power query, see the file attached.
Hi Lauren, Unfortunately, it's out of our control. Teams opens excel in a browser in fact, that Teams window is a browser window, and excel opens i...
You can try to change from time format to decimal system, multiplying the current values with *24*60, instead of 0.003472 you will have 5.00 for examp...
Hi Riste, Not sure what you mean by taskbar, that's a windows section on the bottom of the screen. If you want to put something on the table hea...