Tableau cannot connect to an Excel spreadsheet in that way. While you may be able to get the initial connection to work, there is no built-in capability to refresh the data. Tableau only natively supports connections to Sharepoint Lists.
There may be 3rd party tools that allow for this, however. I do not personally have experience with it, but CData has an option that might help you: Visualize SharePoint Data in Tableau
Thanks Michael, I figured just wanted to make sure.
Do you know if you can connect an SQL table query to tableau and have it update automatically tableau if an entry is made in SQL?
I just need something that when an entry is made, it updates automatically on tableau.
Anna, let's get our terminology right first.
Do you mean "Can Tableau connect to a relational database using SQL"? Yes it can. Or do you mean "Microsoft SQL Server"? Also yes.
As for "updates automatically": Tableau is not a database monitoring tool, so it doesn't react instantly to a change in the underlying database. There are a couple of ways to keep up with changes to the data in near-real-time, though.
1) A live connection to the database. Your users will have to refresh the viz or dashboard to see the change, though. You can't schedule a viz refresh to do that automatically when a change happens to the underlying data.
2) An extract connection to the database with a scheduled refresh every 5 minutes or so. Depending on what kind of change happens (adding a new row vs. changing an existing row) this might or might not work as you anticipate. And your users will still have to refresh the viz or dashboard to see the change.
Does that help?