• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

update excel file without open source file

R

Rodrigues

Member
All
I'm wondering if someone can hep me on this one please, I have an Master excel file where I'm using sumproduct function, which is retrieving info from .csv files (example file1, file2, etc.)
My question is, can I update the master file without open the .csv files?
Many thanks in advance for any help.
Regards
Rodrigues
 
Rodrigues

I doubt that you are directly accessing data from a Text (.CSV) file using Sumproduct

You maybe but it will be accessed by using an SQL Query, Power Query, Power Pivot or other data link, These can all be setup to re-evaluate every x minutes.

It is more likely that your data has been imported once into excel maybe into a Import worksheet or something similar.

If this is the case it will need to be re-imported if it has changed
This can be setup using a macro if required.
 
Hi Hui
Perhaps I haven't explained myself properly, what I'm doing is that, I have csv reports with lots of data, then have designed a Master spreadsheet with the columns/data I need, using some formulas with "sumproduct". The problem is that in order for the Master update values, I have to open the csv files. If I need to use vba so be it, but I'm not familiar with it, could you help me with that?
Regards
Rodrigues
 
You must log in or register to reply here.
Back
Top