I have some Excel 365 files online. Some are shared with EVERYONE, and some are shared directly with me.
I want to have a local copy to them to apply some macros over them.
The share link is for VIEW ONLINE, and I have to press the {File>Create a Copy>Download a Copy} to get a copy.
I did some research and found that changing the “/edit?” to “download.aspx” downloads the file directly. However, this works only for files shared with everyone; it doesn’t work for files with authentication!