I have a number of workbooks that are to be updated weekly each Monday.
What I'm hoping to achieve is that these workbooks update and save
themselves each Monday to save me going into each workbook to kick off
the refresh.Is there a way for me to achieve this? Is FTP the answer
here potentially? A concern I have is that these reports feed into
Tableau so it's important the name of the file itself does not
change.Any assistance would be greatly appreciated!