Controlling embedded excel cell range visible
Controlling embedded excel cell range visible
(OP)
I'm pretty sure I've worked this out before but I can't remember how to do it. My colleage has some kind of pin out table or something in excel that he wants to put into a draft file. However, it isn't showing all the cells he wants.
I thought it was to do with the paper size of the excel file but that didn't seem to fix it.
I thought this had maybe been on here before but couldnt' help it. Any ideas?
Thanks,
I thought it was to do with the paper size of the excel file but that didn't seem to fix it.
I thought this had maybe been on here before but couldnt' help it. Any ideas?
Thanks,
Posting guidelines FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm? (probably not aimed specifically at you)
What is Engineering anyway: FAQ1088-1484: In layman terms, what is "engineering"?
What is Engineering anyway: FAQ1088-1484: In layman terms, what is "engineering"?





RE: Controlling embedded excel cell range visible
Once an excel file has been placed there doesn't seem to be a way of increasing the crop area when additional information is added. The last occupied cell when the spreadsheet is placed dictates the maximum crop area.
What I have done in the past is add some text into a cell a good way from A1 that will cover the area you may need in the future. You can then crop down to the required area but will also be able to increase the crop area, at least up to that cell.
Select the spreadsheet then use SHIFT + LMB over the cell border handles to crop.
This bug has always been there, and should have been fixed long ago.
bc.
2.4GHz Core2 Quad, 4GB RAM,
Quadro FX4600.
Where would we be without sat-nav?
RE: Controlling embedded excel cell range visible
I tried re-inserting the table with him but it still crops a few columns from the right hand side.
I agree, you'd like to think they'd have either fixed it or else quit claiming you could insert excel files as if there was no issue.
What is Engineering anyway: FAQ1088-1484: In layman terms, what is "engineering"?
RE: Controlling embedded excel cell range visible
bc.
2.4GHz Core2 Quad, 4GB RAM,
Quadro FX4600.
Where would we be without sat-nav?
RE: Controlling embedded excel cell range visible
Ken
RE: Controlling embedded excel cell range visible
What is Engineering anyway: FAQ1088-1484: In layman terms, what is "engineering"?
RE: Controlling embedded excel cell range visible
Pellaken - just tried inserting an Office 2003 Excel sheet (create new) in Powerpoint and the behaviour appears the same.
So my apologies to Siemens.
Does it still do this with latest versions of Office and ST2?
bc.
2.4GHz Core2 Quad, 4GB RAM,
Quadro FX4600.
Where would we be without sat-nav?
RE: Controlling embedded excel cell range visible
Patrick
RE: Controlling embedded excel cell range visible
About the only problem I can think of would be the limitations on title rows etc.
What is Engineering anyway: FAQ1088-1484: In layman terms, what is "engineering"?