locked
Excel stops when using Bing maps with only 100 addresses RRS feed

  • Question

  • I have a very small workbook with 1 worksheet. I have about 225 rows and 4 columns. I have inserted Bing map. When I try to plot the addresses I get a warning that I am limited to 100 data points. I selected less than 100. When I resize the map Excel stops. Task Manager shows Excel using about 14% cpu with less than 50% total cpu and 220mb memory.

    This is such a small worksheet I doubt it is 32 bit vs 64 bit issue. Any Suggestions?

    Sunday, December 4, 2016 2:11 PM

Answers

  • Are you using the old bing maps add-in? If so, it has very limited functionality. Excel now has a number of built in map features now. Power maps and power view are two built maps. There is a new map chart that is also in preview for excel as well.

    [Blog] [twitter] [LinkedIn]

    Sunday, December 4, 2016 10:05 PM