Data Import & Export

How to Import Live Data from a View-Only Excel File

Chanuka GeekiyanageChanuka Geekiyanage Nov 2, 2026 870 views

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.

How to Import Live Data from a View-Only Excel File
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.
Before you start

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.

Solution 1Recommended

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.

1
Copy the shared link

Open the view-only Excel file in your browser and copy the full URL directly from the address bar.

2
Open Power Query

In your destination Excel workbook, navigate to the 'Data' tab, click on 'Get Data', select 'From Other Sources', and then choose 'From Web'.

3
Paste the URL

Paste the copied view-only link into the URL dialog box and click 'OK'.

4
Authenticate your account

If prompted, sign in using the 'Organizational account' option with the exact credentials authorized by the file owner.

5
Select and load data

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.

Use Power Query to Connect to the Web Link
Authentication Limits: If you get stuck at the account-verification code stage, the secure link's settings likely prohibit API or query-based access, requiring the owner's intervention to change permissions.
Free Microsoft Office alternative

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.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Simplifies file sharing and team collaboration without complex link-restriction loops.Lightweight installation with a user-friendly, familiar interface.Completely free to download and use for your daily spreadsheet and data management tasks.
microsoft office alternative - wps office

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.