This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
hi, i have a sercure online access link to a view only file shared by my vendor.. how can i get live data to import to my own excel file?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
stuck at Account verification code stage, my office 365 account is the same account shared by the vendor
try querying it in power query see if it can get the data.
that would means if i have to get new data I need to download again, kinda want to make it download data automatically.
I managed to get live data from a google sheet with view only access, so I am thinking of doing the same from a excel view only access
click on file>save>download a copy
i tried get data from the web, but unable to get past the Account verification code stage, my office 365 account is the same account shared by the vendor