Unanswered: Linking cells: open source to update values
I created a source file (.csv) that contains two columns and several rows. This source file is filled (updated) by a SQL process that runs everyday.
The source file is input for a report in Excel. I would like to automatically update the Excel report when it is opened. However, although it looks like I linked the correct file, worksheet and range, I can only update the Excel report after I manually open the source file. But that's not what I want, I don't want to see the source file.
I see this was posted a while ago but no answer yet.
Rather than link to the source file (with formula), use an Excel query table with setting "Refresh data on file open" enabled. Update will then be quick & seamless - and no VBA either. Refer Excel menu path Data, Import External Data, New Database Query
(You might even be able to eliminate the csv file altogether and put the SQL straight into the Excel query table, if the SQL is not too complex and access is available to the database from Excel.)