Can we place an Excel file in a shared location and use it to develop a report and refresh it in regular intervals?

Yes, we can do it, but for better performance, we have to use Extract.