1 of 1 people found this helpful
Unless you have server and can find an add-in for excel to show a live web page, then no.
That's what I had thought. I do have a server, but I haven't run into any add-in's for excel, as of yet, that could do what I want to. I may have to look at things differently for future applications.
Thanks for the help.
Welcome, from a quick search I couldn't find any add-ins.May be a good excuse to depart from Excel...
Hey Don -
You actually can do this without too much effort if you don't mind getting your hands a tiny bit dirty
Using Excel 2010:
- In Excel 2010 Options, goto Customize Ribbon, and turn the "Developer" tab on.
- Switch to the Developer Tab, and choose "Insert". In the bottom right-hand corner of the dialog that opens, choose More Controls.
- Scroll down the list, and choose Microsoft Web Browser. Click OK.
- With your mouse, "draw" the area on the worksheet that you want the control to occupy. When you are done, a big fat Windows icon will occupy that space.
- Double-click the big fat Windows Icon. A code editor will appear.
- You'll see two drop-down boxes at the top of this window. Something like "WebBrowser1", and "StatusTextChange". Choose the second drop-down box (StatusTextChange), and select "Activate".
- Inside the code block that says "Sub WebBrowser1_Activate", type: WebBrowser1.Navigate("http://server/views/workbookname/viewname")
- Save your changes.
I've attached a sample which embeds a sample viz out on Public that I like a lot.
EmbedTableauInExcel.xlsm 19.2 KB
Thanks Russell! This is exactly what I was hoping to be able to do. I really appreciate your help with this one.
I have another question on the forum in regards to an issue with adding zero's to my data to get a BDI. Maybe you can shed some light on this issue for me if you have a moment to check it out:
Huh! Who knew - I searched for "show web page in excel" but that didn't come up - nice.
Yeah, you can embed Microsoft's browser control into pretty much anything - that's how folks generally get Tableau into a Windows application - and how the PowerPoint add-in we all enjoy so much works.
H Don -
I won't pretend to completely understand the other issue you refer to, but it appears you're adding zeros in order to drive the correct relationships between rows/datasets you want to compare...but you're also paying "the cost", as nothing comes free (except the awesomeness in Tableau).
While this might not be an option for you, it might make sense to consider using a true ETL tool to try and tie your values together the way you need them rather than jump through hoops in Tableau to avoid same.
Have you considered this approach?
We do use SQL for most, if not all of our data. We have worked with data blending, different joins, adding zeros, etc., but we still haven't found the right combination to effectively make this work for us without overloading our server with data (zeros).
I do have 2 examples of the data that I have set up in Tableau (with and without 0's), but due to the nature of the data I would prefer not to post it on line. I will have this data and the examples with me in San Diego where I hope to speak with someone who might be able to help me out while I'm there.
If there's anything you could suggest that might be helpful, it would be greatly appreciated.
I am hoping that I can repeat the same problem with the Superstore data set today so that people on the forum can play around with this issue to see what they can come up with.
Thanks again for your suggestions,