RE: Insert Object -> MS Excel Worksheet: Only part of the data is being displayed

393
2
03-24-2011 07:30 PM
LoganWinston
New Contributor
I am trying to insert an excel worksheet in my map in ArcMap (layout view), and when I "Insert Object -> MS Excel Worksheet", only a selected portion of the actual data I would like to display shows up in the map. When I try to resize, this merely makes the fonts bigger, but there is no obvious means to display exactly the data that I want to display in ArcMap from my excel worksheet. Help me obi-wan!
Tags (2)
0 Kudos
2 Replies
JohnSobetzer
Frequent Contributor
We have found that the best way to get Excel data to display properly in ArcMap is to copy and paste it.  I think you would find this is the most common proposed solution on the forums to a recurring issue.  Unfortunately if we export to pdf that doesn't always work. The table may not display completely for instance in the pdf.  It looks great in ArcMap.  So since we have Adobe Acrobat, we have found printing to pdf often works (although that doesn't produce layers and sometimes messes up something else), but the only sure way is to create stamps and add them to the pdfs after they were exported.  Clumsy.
0 Kudos
StevenWeaver1
New Contributor II
John,

Thanks for this post.  As it was for the original question so it holds true for 10.1SP1. Copy and paste continues to work like a champ.

Cheers,
Steve
0 Kudos