Power query - Updating files before getting values

[DaveyD]

I have a query that retrieves information from multiple excel files in a folder
The problem I am running into is that those files have formulas that depend on the current date
Seemingly, when power query retrieves the data, it doesn't allow the formulas to update first
This results in incorrect data in my report.

Is there a way to fix this issue without having to open every file first to have it update and save?


Thanks,
David

 

[arunsjain]

You can include a macro to open, save and close files from folder before running power query refresh.


Try link below.

https://www.ozgrid.com/forum/forum/...o-to-open-save-and-close-multiple-excel-files

 

[DaveyD]

@arunsjain - thanks
That is what I did. I was just hoping for an easier solution.
Maybe there would be some type of an option in the query to update the files when reading the data.....

 

[sandy666]

do everything with Power Query without any formula(s)