Update a linked file to Pivot Table

[Mohammed Salah]

Hi all,

I have a pivot table reading data from an excel file an a folder. This excel file is auto-saved daily from outlook. Issue is, the file name is dynamic and changes with some kind of a code in the end so I have to updated the link manually in the pivot table to read from the recent file. Is there a way/code to direct pivot table to read from the recent file in the specified folder? appreciate your support and help