excel tables import into layout view

nimitz

Hi all,
I am trying to mimic a mxd that was done a year ago with updated data. The layout view has monitoring sites that have updated
data. The problem I have is I want to make the tables look EXACTLYthe same as the previous. The tables have been imported from
excel done through cut-and-paste. I am trying to copy the font, borders, color, etc, but it's a little different. I'm curious if there was a "better" way
to get the tables to look alike. I can get it close, but it's not exact.

Thanks all and have a good weekend,

R~

DonovanCameron

Two ways to do this.

1st, format the table in excel how you need it to look.
Highlight the cells you need and Copy (Ctrl+C) then Paste (Ctrl+V) into the arcmap layout.

That leads to a more static type of table.

A better way is to use the import tool.

From arcmap, select the "Insert" pulldown menu and select "Object...".
Click the radio button beside "Create from File" and "Browse..." to your file and once found, press OK.

This table that gets inserted can then be formatted on the fly.
Simply double click it, which will open up the table in excel where you can apply your required formatting and see it in the layout in real-time. No need to save the excel file, just format and close it to see the changes in the layout.

I've found only one small drawback for using the "Insert" method and that is that there seems to be a limit to the amount of records that will be brought in.

I can't remember what the row limit was or if it was a bug that got patched for 10.1....