Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get the Excel Map Data in Office 2003?
Office 97 had a function in Excel which allowed simple maps with optional
info (Capital cities/airports etc) to be added. Office 2003 does not come with this as standard. The help function tells you to add XML data, which is all well and good, but does not point you to where it is lodged (presumably on a Microsoft site). As a draughtsperson who works with maps, this was a very useful feature. |
#2
|
|||
|
|||
Not available with versions 2002 and 2003.
MS Map Point is now the application used. Costs about $250.00 US. An alternate is to use MapInfo product(which was the Excel 97 and 2000 product). Very costly at minimum $595.00 US just for upgrade. http://www.mapinfo.com/location/integration But............found this tidbit on the net thanks to Debra Dalgleish. Mystery of the Missing Map Tool: If you believe Microsoft, the Excel Map tool is permanently out of action in Office XP; it's been replaced by the $249 mapping and data analysis package MapPoint 2002. Microsoft assures you that you can still open and view Excel 97 and 2000 files that contain maps in Excel 2002, but you can't alter them or create new ones. Well, I don't always believe what Microsoft tells me. In fact, I've got the Map tool working pretty well from inside Excel 2002. To be sure, my PC still has Excel 2000 installed as well, but this trick might be worth a try even if you don't, as long as you still have your Office 2000 CD-ROM and don't fancy shelling out the cash for MapPoint: Using Excel 2002, open an Excel 2000 file with a map in it and double-click the map. If you're prompted to, place your Office 2000 disc in the drive so it installs the Map tool; the application will then load and you can alter the map from within XP. You can also create new maps in Excel 2002 using Insert / Object / the Create New tab / Microsoft Map and clicking OK. Choose the country, then, when the map is created, choose Insert / Data to select the data for the map. It isn't as easy as it used to be, but it does work. Gord Dibben Excel MVP On Wed, 1 Jun 2005 03:15:01 -0700, "Sandhurst37" wrote: Office 97 had a function in Excel which allowed simple maps with optional info (Capital cities/airports etc) to be added. Office 2003 does not come with this as standard. The help function tells you to add XML data, which is all well and good, but does not point you to where it is lodged (presumably on a Microsoft site). As a draughtsperson who works with maps, this was a very useful feature. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel MS Office 2003 | Excel Worksheet Functions | |||
Where has the data map tool gone to in Excel 2003? | Excel Discussion (Misc queries) | |||
Quattro Pro files in Excel 2003 | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |