I have officially broken the Tableau Community! After 42 views, no one has accepted the challenge of this question. I hope I didn't violate an unwritten rule of forums, but barring that, I guess this issue is uniquely my own to tussle with, yay!
1 of 2 people found this helpful
There mus be simple that's caused the error though.
Is Tableau connecting to the proper file ?
Does the file exist at that location (and available to be opened) ?
Does the excel file contain a sheet called Results_Table ?
Usually when I've seen this in the past, one of those three questions will reveal the problem that Tableau has with accessing the data.
Thanks Chris. Unfortunately this is a strange issue. I've tried creating a brand new Tableau workbook and creating a brand new connection to the Excel file in question. Again, not a single excel tab nor named range appears to the left. I've tried loading other Excel files and I DO see the tabs and named ranges so I've narrowed it down to a single (or set of) excel file(s). I will try copying and pasting some of the important tab to a brand new Excel workbook and see what happens.
I do not wish this issue on anyone, but something happened. I can only assume I've been hacked or hit with a virus, however this is a business computer that gets used for nothing but work. If anyone out there has ever come across anything like this, I'd love to hear from you.
Just wanted to provide the rest of the story. Yes it was fixed. How? No clue, just started working again, I can't explain it. Been using Tableau since 2012 so not my first time at the rodeo.