JustSomeDude
IS-IT--Management
I am trying to link a large spreadsheet to my InDesign publication. I am doing all the formatting in Excel.
The linked table stretches well beyond the page limit. I noticed that there seemed to be a lot of vertical space in each cell (i.e., space above and below numbers). So, I tried to shrink the row height a little to see if I could get it to fit.
For some reason, if I leave it at the original row height(5.20), it stretches way beyond the page limit, but leaves a good deal of vertical space in each cell...yet, if I lower the row height by one click (4.80), it shrinks the table such that it is a tiny thing in the corner with the red dots in the cells. I've tried setting the row height to something in-between, but Excel only allows 5.20 or 4.80.
Can anyone suggest anything?
Also, as background, I am trying to get it such that end users can work with Excel and input their data, then have that data update in InDesign (so I want to set up a standard publication and give the end users a template that they will fill out each week). Therefore, I am not doing any formatting in InDesign (because as I understand it, the formatting in InDesign will not keep when I try to update the links).
Thanks for any advice.
The linked table stretches well beyond the page limit. I noticed that there seemed to be a lot of vertical space in each cell (i.e., space above and below numbers). So, I tried to shrink the row height a little to see if I could get it to fit.
For some reason, if I leave it at the original row height(5.20), it stretches way beyond the page limit, but leaves a good deal of vertical space in each cell...yet, if I lower the row height by one click (4.80), it shrinks the table such that it is a tiny thing in the corner with the red dots in the cells. I've tried setting the row height to something in-between, but Excel only allows 5.20 or 4.80.
Can anyone suggest anything?
Also, as background, I am trying to get it such that end users can work with Excel and input their data, then have that data update in InDesign (so I want to set up a standard publication and give the end users a template that they will fill out each week). Therefore, I am not doing any formatting in InDesign (because as I understand it, the formatting in InDesign will not keep when I try to update the links).
Thanks for any advice.