I am trying to create an automation:
When I go to find the workbook (it has multiple tables and power queries) I am unable to find the file.
Thank you for anwswering. What I found out is you can't straightforwardly automate or make a list with a excel macro - which is why it wasn't in the folder.
Did you Check In "Settings" > "Site Contents" and looking through the libraries and folders to see where the workbook is actually located?