How to Import Live Data from a View-Only Excel File
Question details
The user wants to extract and automatically refresh live data from a view-only Excel file shared via a secure link into another workbook without manually downloading it each time.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Attempting to establish a live data connection to a shared, read-only Excel file to keep a local workbook updated automatically.
- Observed behavior
- The user can view the file in a browser but struggles to establish a refreshable data connection. Conventional linking methods and Power Query often fail due to strict view-only permissions and authentication barriers.
Ensure you have the exact sharing link provided by the file owner and verify that your Microsoft or Office 365 account has at least view-level permissions authenticated for that specific file.
Use Power Query to Connect to the Web Link
Power Query can sometimes bypass standard workbook linking limitations by treating the shared Excel link as a web data source.
Note that success depends entirely on the specific sharing permissions set by the file owner. If the link requires complex browser-based authentication or explicitly blocks external data queries, Power Query might still face access issues.
Open the view-only Excel file in your browser and copy the full URL directly from the address bar.
In your destination Excel workbook, navigate to the 'Data' tab, click on 'Get Data', select 'From Other Sources', and then choose 'From Web'.
Paste the copied view-only link into the URL dialog box and click 'OK'.
If prompted, sign in using the 'Organizational account' option with the exact credentials authorized by the file owner.
In the Navigator window, select the specific sheets or tables you want to import, then click 'Load' to bring the refreshable data into your workbook.

Request an Alternative Data Connection from the Owner
If Power Query cannot authenticate the view-only link due to security policies, the file owner must provide an alternative supported data connection.
Try WPS Office for Seamless Spreadsheet Management
If you frequently struggle with complex authentication barriers and restrictive sharing permissions in Microsoft Excel, consider switching to WPS Office. It offers a lightweight, highly compatible spreadsheet environment that makes sharing, collaborating, and managing data straightforward.

Frequently Asked Questions
Why does my view-only Excel link work in the browser but fail in Power Query?
Browser links often use session-based cookies and multi-factor authentication that Power Query cannot seamlessly replicate. If the sharing setting restricts API or external query access, Power Query will be blocked even if your browser has access.
Can I link directly to a view-only Excel file using standard cell references?
Standard cell references usually require the file to be opened locally or accessible via a direct network path. They do not work reliably with secure web-based sharing links.
Is there a way to automatically refresh data from a view-only link like in Google Sheets?
Google Sheets handles view-only web links differently, often allowing functions like IMPORTRANGE out of the box. In Excel, you must use Power Query's 'From Web' feature, but it strictly depends on the host's sharing permissions allowing data extraction.




