We frequently have to update excel sheets that contain reports as number, images, and pie charts and import it in our data view in ArcMap (sometimes 13 times a day). We do it by copying the row/column from excel and paste in in ArcMap Layout view . We want to automate this task by linking excel to Layout view, using Insert--> Object and grab that excel file, you can save so much time and and step this way. The problem is when we do this, the excel file gets messed up. The alignment of the texts changes and some texts don't show up and so many other problems.
Is there any other way to do this and not lose the format from excel?
We have ArcMap 10.1.