MindJet Diary: Dymamic Display of Data from Excel
Idea Map, Mind Map, Visualization Tagged Idea Mapping, Mind Mapping 1 Comment »We’ve been using MindManager to create weekly and monthly reports (status update and accomplishments maps), which we find to be a better format than PPP and Excel dashboards. The Excel Range function that we recently discovered is extremely helpful. It allows us to display selected data from a parent spreadsheet residing in SharePoint on the map by creating a dynamic display. This eliminates duplicate data entry – once a parent spreadsheet is updated, data in the spreadsheet within the map is updated automatically and there is no need to update data in the map manually. This saves us a lot of time and helps in prevening errors that come from double entry. We’ve been very excited about this function.
There was a problem though – a person who doesn’t have access to a parent spreadsheet will not be able to see data on the map. I called MindJet CS and was delighted to find out that you can actually break a link to a parent spreadsheet, which in turn will convert the datasheet on the map to a static form. It is very easy – just right click on an Excel icon shown on a map’s spreadsheet and select Disconnect from Microsoft Excel. Problem solved!
![[blinklist]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/blinklist.png)
![[BlogMarks]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/blogmarks.png)
![[Blogsvine]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/blogsvine.png)
![[del.icio.us]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/delicious.png)
![[Digg]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/digg.png)
![[diigo]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/diigo.png)
![[Facebook]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/facebook.png)
![[Jeqq]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/jeqq.png)
![[Ma.gnolia]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/magnolia.png)
![[Mister Wong]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/misterwong.png)
![[Netvouz]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/netvouz.png)
![[Newsvine]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/newsvine.png)
![[Propeller]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/propeller.png)
![[Reddit]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/reddit.png)
![[Slashdot]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/slashdot.png)
![[Sphinn]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/sphinn.png)
![[StumbleUpon]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/stumbleupon.png)
![[Technorati]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/technorati.png)
![[Twitter]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/twitter.png)
![[Email]](http://powermapping.ideamappingsuccess.com/IdeaMappingBlogs/wp-content/plugins/bookmarkify/email.png)




