Controlling embedded excel cell range visible

[KENAT]

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,

Posting guidelines faq731-376

http://eng-tips.com/market.cfm?

(probably not aimed specifically at you)
What is Engineering anyway: faq1088-1484​

 

[beachcomber]

I've seen this but never found a cure for it.
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?

 

[KENAT]

Thanks Beach.

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.

Posting guidelines faq731-376

http://eng-tips.com/market.cfm?

(probably not aimed specifically at you)
What is Engineering anyway: faq1088-1484​

 

[beachcomber]

A bug for 13 years - not bad.

bc.
2.4GHz Core2 Quad, 4GB RAM,
Quadro FX4600.

Where would we be without sat-nav?

 

[Kenny_G]

My understanding of the "bug" is that it is an issue with Excel, and that same issue would be experienced no matter what product you inserted the Excel sheet into. At one time, the way you inserted it had an effect on the issue such as whether you did "Copy & Paste", or "Insert Object From File" or "Insert Object New". We always use "Insert Object From File" for best results.

Ken

 

[KENAT]

Thanks we used "Insert Object From File". I suggested he look at using a table.

Posting guidelines faq731-376

http://eng-tips.com/market.cfm?

(probably not aimed specifically at you)
What is Engineering anyway: faq1088-1484​

 

[beachcomber]

Limitation with table is that it is only a table, not a spreadsheet.
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?

 

[PatCouture]

I recall having the same isssue with Office 2007 and ST1 draft. I also used Insert object from file.

Patrick

 

[KENAT]

Well, for what it is, I think a list of pin outs or something like that, a table is all that's needed.

About the only problem I can think of would be the limitations on title rows etc.

Posting guidelines faq731-376

http://eng-tips.com/market.cfm?

(probably not aimed specifically at you)
What is Engineering anyway: faq1088-1484​