I have an A0 map. I want to put a table underneath it. I want to insert an Excel object as the table. When I do this, the size of the table is 19 fields/columns. I cannot increase this number of columns, even though this is only half the width of an A0 portrait page. The table is only 32.1cm wide when the page is 84.1cm wide. I want it to, effectively, display 84.1cm's worth of cells, not just stretch 19 columns 84.1cm wide.
I have set the printer as the A0 plotter (HP designjet HPGL/2). I selected A0 page size in the Excel object. In fact I set this as the default setting in case a non A0 default setting was causing the problem.
I know that Word cannot print anything bigger than 55.7cm, but Excel is supposed to be able to print more (presently the object isn't even 55.7cm wide...). Is it correctc excel can print A0 if an A0 printer's installed? I can edit the size of the Excel Object in Arcmap, but this only makes the table bigger, not display more fields. I have also tried opening the excel object from a file rather than typing data straight in. This file contained far in excess of 19 fields, but the object only displays 19.