3D Map not refreshing

[Madraykin]

Hi all,

I have been having a play around with the 3D Maps function in Excel and it is doing what I want it to in terms of visualisation.

It is feeding from a table which will update with different values depending on a location that I choose from a drop-down box. All of this is done on a worksheet called (imaginatively) 'Visualisations' - the problem is that when I choose a different location and then open 3D Maps and hit 'Refresh Data' it won't refresh and instead tells me that it can't find 'Sheet 2'

I don't understand why, when it is pulling from the data table on Visualisations, that it would suddenly be looking for a non-existent 'Sheet 2' in my workbook

Does anyone have any bright ideas on how to make it so that I just have to click refresh data and the map will update (I have imported my .kml file so I have the correct custom boundaries) - currently I have to delete the tour and recreate a new one every time which I don't want to have to do.

Any help appreciated!

Mads

PS - wasn't sure if this needed to go in PowerBI - apologies if so

 

[Madraykin]

Ah - no worries I fixed it - there was a random old table in the Data Manager that it was trying to redirect to - removed that and all is now good!