×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Controlling embedded excel cell range visible

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,

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"?

RE: Controlling embedded excel cell range visible

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?

RE: Controlling embedded excel cell range visible

(OP)
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: 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"?

RE: Controlling embedded excel cell range visible

A bug for 13 years - not bad.

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

Where would we be without sat-nav?

RE: Controlling embedded excel cell range visible

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

RE: Controlling embedded excel cell range visible

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?

RE: Controlling embedded excel cell range visible

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

Patrick

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources