💻 Software
How do you update an Excel file (Data Refresh and update formulas) WITHOUT opening the file?
Fresh5 days ago
Mar 15, 202660485 viewsConfidence Score0%
0%
Problem
I have an Excel file that want to update and save automatically with out having to open it or manually interact with. Manually, I open the file up and hit data refresh which goes and does a SQL query and then hit F9 for the formulas to update and then I just close/save. (I then would mail the file …
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How do you update an Excel file (Data Refresh and update formulas) WITHOUT opening the file?
Low Risk
My workaround is to record a Macro in the Excel file (so you have to use .xlsm file extension) (first you will need to go to Programs >> Windows Powershell and type at prompt to allow the script to run) : Then I use a Powershell script that does the…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix