MS MAP  
Author Message
lindon





PostPosted: Mon Mar 21 19:25:54 CST 2005 Top

Excel Misc >> MS MAP

I used to use a map function in excel97 which embedded useful maps onto excel
spreadsheets. I can't find it now I have Office2003. Does anyone know if
it's available for Excel2003.

Excel155  
 
 
Paul





PostPosted: Mon Mar 21 19:25:54 CST 2005 Top

Excel Misc >> MS MAP Matt, this feature is no longer in excel versions newer than 2000,
Microsoft now has MapPoint to use with it's office applications, but you
will need to purchase it. Have a look here
http://www.microsoft.com/mappoint/products/default.mspx


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003



> I used to use a map function in excel97 which embedded useful maps onto
excel
> spreadsheets. I can't find it now I have Office2003. Does anyone know if
> it's available for Excel2003.
>


 
 
Gord





PostPosted: Mon Mar 21 19:58:35 CST 2005 Top

Excel Misc >> MS MAP Matt

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 Mon, 21 Mar 2005 15:53:02 -0800, "Matt-mgs"


>I used to use a map function in excel97 which embedded useful maps onto excel
>spreadsheets. I can't find it now I have Office2003. Does anyone know if
>it's available for Excel2003.
>

 
 
Gord





PostPosted: Mon Mar 21 20:21:16 CST 2005 Top

Excel Misc >> MS MAP The site Debra referred to was...

http://www.winplanet.com/article/1818-.htm


Gord