Datamap in XL 2002

A

Alf

Hi,
I used to use the Datamap tool in XL 97.
It doesn't seem to be available in the installed version.
Is there some way to use it in XL 2002 ?

Is there a plug-in, macro, or something needed to get it running ?
Or something better available (for free) ?

TIA

N.L.
 
A

Alf

Thanks, but the link appears to be out of date.
Did searches on the site, no luck.
Did searches on the Goooogle with "datamap site:winplanet.com", no luck.
Did some sneaking using their current folder system
http://www.winplanet.com/article/3997-.htm and similar .... no luck !

Any other places I could look to get the info ?

TIA

N.L.
 
A

Alf

Just found some info here :

http://cws.internet.com/article/1818-.htm

Middle of the page ...
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.

The moral of this story? Just because something doesn't seem to be there
doesn't mean it isn't somewhere. So if your favorite tool isn't available in
Office XP, don't give up before having a good look around the Microsoft
Office, Office downloads, and Office Web tools sites. You might get lucky
and find it.
 
D

Debra Dalgleish

If you still have your Office 97 CD, you may be able to install the Map
utility from that, and use it in Excel 2002, as the article describes.
 
A

Alf

OK, I just reinstalled XL 97 + SR-2 and the Microsoft Map object has become
available as an Insertable object both in XL 97 and in XL XP (2002).

It's working fine.

BCNU

N.L
 
Top