@Akshay_Petkar , is the Shared Drive something like a Sharepoint Site's document library? It's not uncommon for businesses to sync these locally. If yes, then you can just use a Sharepoint Connector or build one. 

If this is just a typical network drive, there's really no way to expose this directly to Databricks. However, if you leverage the Databricks SDK/CLI/API, then you could move that file programmatically from the Shared Drive into your Databricks environment 🙂. Once it's in your databricks environment, you can then read the excel file. If your IT team don't allow this, you can always propose an SFTP route instead.

I wrote a blog on getting data into databricks manually/programmatically, in here I used the CLI to move it from a file from my machine to my Databricks environment:
https://community.databricks.com/t5/community-articles/episode-1-getting-data-in-learning-databricks... 

And I wrote a blog on working with Excel files in Databricks: 
https://community.databricks.com/t5/community-articles/episode-2-reading-excel-files-learning-databr... 

If you don't know whether to use the CLI/SDK/API here's a great article to explain the differences: https://alexott.blogspot.com/2024/09/databricks-sdks-vs-cli-vs-rest-apis-vs.html 

All the best,
BS