I have been using Tableau 10 without any issue , connecting to multiple excel , databases . Could you please check if the below resolves your issue .
- Check if you have the Tableau 10 Beta installed . Un-install Tableau 10 Beta and then install your Tableau 10 again.
Our office has been having the same problem!
Have you been able to get this issue resolved??
We do not have Tableau Beta installed. Thank you for the suggestion though! It seems to be an intermittent problem, yet occurs with such regularity that it becomes hard to work. It is almost as if the file corrupts sometimes and doesn't want to regularly reconnect.
Still no solution, but glad to hear others are having the same issue (even though I am sad for you!) because that means hopefully someone else is working on a fix.
How are you getting around the issue? Are you creating new files and replacing them in Tableau?
Well, it has been very disruptive to work for me, that is for sure. So far I either work on updating things when it lets me, or just start over again in a new tableau file. It is disappointing because it is so much extra work, but I am lucky that many of my projects only need updates a couple times a year. I can literally just check it daily hoping for a good one. I am running out of time, though, and have some with tons of calculated fields so I am really hoping for an answer.
Something I haven’t tried working on is formatting. I know in some other programs I use (like R) lots of crazy formatting can be an issue. I can’t change the excel files I use to because they are shared and copying/pasting values only to a new sheet each time I need to update would be too much work, but if it works for your uses you might give it a try. If you do find anything, please let us know!
I am just trying to guess the root cause for the problem per my experience . As you say it has been an intermittent issue. Did you noticed any pattern there ? For e.g. Do you see that you are able to connect to the file correctly in the first go , but later when you make some changes in the excel thereafter the problem starts appearing.
Also in one of my earlier encounter with a similar kind of issue but with my-sql connectivity , i had a mysql driver installed on my system i.e. mysql 3.51 odbc driver which was required by earlier version of tableau to connect to mysql and i was facing all kind of problems in connecting . But the moment i removed the 3.51 driver from my system the connection started working smoothly as the latest version of tableau already had the requisite.
So what i am suggesting is you might have to do a system scan of yours and try to figure out if you have some similar root cause . Thanks.
I think we might have an answer... 10.0.1 | Tableau Software just came out and one of the bugs it fixes is:
In some environments with higher than expected network latency, Tableau Desktop would crash when connecting to a database.
I am going to upgrade tomorrow and see if this fixes the issue. My work does suffer network congestion and issues sometimes, so this makes sense to me, especially given the intermittent nature of the problem. I hope it works for everyone else as well.