How to open Excel without refreshing data
Fresh3 days ago
Mar 15, 202693480 viewsConfidence Score0%
0%
Problem
I have an Excel spreadsheet with several connections, that are set to refresh automatically (Refresh Data when opening the file). I think there is a problem with one of the queries because it hangs upon opening and I can't even see what it is trying to execute. Is there a way to open the file w/o t…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to open Excel without refreshing data
Low Risk
You can also open the workbook in Protected View. In the open file dialog box, you can click on the down triangle next to the word "Open" and select "Open in Protected View".
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix