Is the source an extract in Tableau? Try and switch back to a live connection and then extract again.
It was an extract, but I tried that and it didn't seem to help. I just tried it with a very basic excel file
age gender 2 m 3 f 4 m 5 m 6 f 7 m
to which I linked to, then added a third field and extended the named range,
age gender eth 2 m e1 3 f e2 4 m e3 5 m e1 6 f e2 7 m e3
but it still won't find the extra data when I refresh. But I noticed that if I swap the 2nd and 3rd cols..
age eth gender 2 e1 m 3 e2 f 4 e3 m 5 e1 m 6 e2 f 7 e3 m
.. it then ignores the 'gender' column. I'm beginning to think Tableau doesn't really use the named range but swaps it for absolute cell reference?
I've also did my example without named ranges and just used sheet names and everything worked properly! This is a bit annoying as I'd used named ranges as I'd thought they'd give me more control.
1 of 1 people found this helpful
I think the only purpose of using named ranges if you don't want to format the excel file for tableau to consume (i.e., you don't want to remove blanks, title, etc. at the top.)
I've never bothered with a named range, but was able to replicate what you are experiencing. If you know you are connecting to Excel with Tableau, why bother with the named range? Just put your field names in row one and data below. You can then add stuff and Tableau will automatically pick it up when you refresh.
Thanks for checking. I'll switch to sheet references for now (I think they should either fix this feature or drop it - there's not much point linking via a named range if it doesn't update properly)
I am experiencing the same problem as Michael. I use an Excel named range as a data source.
I have additional data/calculations in other columns in the spreadsheet that I do not want to import into Tableau or list in the data source.
Does anyone else have suggestions to fix this problem?
Using Michael's same example, I do not want to include firstname or lastname so I have age and gender identified as a range:
firstname lastname age gender Jason Farnsworth 2 m Jane Card 3 f Ron Frank 4 m Stan Grant 5 m Karen Drake 6 f Steven Hardy 7 m
I was encountering the same issue recently. Apparently when Tableau first pulls named ranges from Excel, it creates a shadow extract and hard codes the data range. Therefore, when it refreshes it does not pull new named range values from Excel, so new data rows or columns don't make it in. Thankfully, Tech Support provided a workaround that will work with any opened Tableau files:Re: Data refresh is not including new columns from Excel spreadsheet. Hopefully they can fix this soon. I dont have information if this fix continues to a live connection from Server.