Change view of embedded worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After I create a new Excel object within Word, I do all my spreadsheet work
and go back to the Word doc and everything is OK. I then add several rows
and/or columns and the new changes don't show up in Word. I can change
formatting, background colors, fonts etc and those changes I see but only the
cells that were included with the initial creation. Cropping, resizing
doesn't seem to work. I've run into this with embedded Excel sheets in
powerpoint too. Any suggestions?
 
I believe you are limited to one page of information.
If you don't have a full page,a nd it is still cutting you off, try this.
Close Excel. In Word go to Edit|Links. Open the Excel Source. Resize the
Excel Window that opens so that it is big enough to show all the data you
want in the Word Document.
For some crazy reason this seems to work sometimes.

Your other altenative is to make the Font Sizes smaller in Excel.

I've never seen a better solution to this problem, but maybe someone else
can come up with one.

tj
 
Changing the font size doesn't work. I also tried changing (shrinking) the
row height and the "window" within the word doc resizes but doesn't who any
more data.

I tried making a new sheet within the work book and even that didn't work.
If I created a new sheet with just 1 cell filled, then I only see the 1 cell.
If I then paste in a copy of the first sheet, I see the same as I did with
the original. it is almost as if the view area is limited to a dozen or so
rows and a handful of columns.

Changing print area (and setting and clearing it) doesn't do anything
either. What a major bug.
 
Failed to mention that the excel window is fully open and the spreadsheet I'm
inserting is only about 16 rows by 5 columns.

I just now finished a test and created a sheet of 17 rows and 7 columns. I
only see 9 rows and 4 columns of data. Even if I cut the width of the
columns in half, in Word I still only see the 4 original columns but with the
new narrower width.

as far as I can tell, this is unusable as a feature.
 
Have you tried Right-Clicking on it in Word and updating the Link?
Not that it will be much consolation, but I can't duplicate your problem.
Did you open Excel by Double-Clicking on the embedded object in Word? How
big was it then? Be sure Excel is closed before you try this.
Then, Right-Click on the object in Word and choose update link. Or, did you
not link the Object when you created it?

tj
 
Back
Top