I have pasted an Excel Worksheet Object into my Word document. I need to use the Excel functions (filtering) on this object so it must be editable (either within the Word doc or in separate Excel doc). It works correctly however it resizes (expands) itself within Word when edited or opened. Sometimes it returns to the correct size after a few seconds but other times it does not and I can only fix it by using undo. Do you know why it does this or what I can do to stop it from expanding?

1. Microsoft Excel Worksheet Templates

Henk57 07.12.07 13:34. It depends how you insert the Excel sheet. As you describe I think you embed it, as you call Excel from within Word.

• Q: Paste Special - Microsoft Excel Worksheet Object I am trying to copy a excel spreadsheet in to word with Paste Special - Microsoft Excel Worksheet Object. Each time i perform this task it crushes.
• Fortunately, linking an Excel object in Microsoft Word is easy. Copy the table from the example workbook, and head back to Microsoft Word. Again, click Paste > Paste Special in the Home tab. Again, select Microsoft Excel Worksheet Object. This time, however, you’ll need one more click. On the left side of the window, you’ll see two radio buttons.

My approach would be to link the Excel sheet to Word dynamically. In Word 2003, select the table (cell range) you want to copy to Word in Excel, Copy, and go to Word. Then Edit/Paste Special and tick Paste link, and select under As: Microsoft Office Excel Worksheet Object. Resize as needed. Make any changes in the Excel sheet and these are automatically reflected in the Word table (You might have to right-click the Word table and choose Update link). There is a price to pay, though: the Word file will be significantly increase in size so if you do this with many tables it might become impractable.

Henk57 matters@discussions.microsoft.com Size matters 09.12.07 16:14. Size matters;2521296 Wrote: Thank you for your reply, while it has provided a differrent and cleaner way to inser the excel worksheet I am still getting the problem with it resizing in word. When I now double click the worksheet in Word it opens in Excel. If I edit and save it and then update the worksheet in Word it stretches in size and goes off the page.

Then make sure the reference Microsoft Office Word 12.0 Object. You can command Excel to paste your table into MS Word. Word has a special method.

Any ideas? 'Henk57' wrote: - It depends how you insert the Excel sheet. As you describe I think you embed it, as you call Excel from within Word. My approach would be to link the Excel sheet to Word dynamically. In Word 2003, select the table (cell range) you want to copy to Word in Excel, Copy, and go to Word.

Then Edit/Paste Special and tick Paste link, and select under As: Microsoft Office Excel Worksheet Object. Resize as needed. Make any changes in the Excel sheet and these are automatically reflected in the Word table (You might have to right-click the Word table and choose Update link). There is a price to pay, though: the Word file will be significantly increase in size so if you do this with many tables it might become impractable. Size matters;2515701 Wrote: - I have pasted an Excel Worksheet Object into my Word document.

I need to use the Excel functions (filtering) on this object so it must be editable (either within the Word doc or in separate Excel doc). It works correctly however it resizes (expands) itself within Word when edited or opened. Sometimes it returns to the correct size after a few seconds but other times it does not and I can only fix it by using undo. Do you know why it does this or what I can do to stop it from expanding? Thanks.- - Henk57 - Make sure you have the aspect ratio locked.

You can do this in Format Object (check both 'lock aspect ratio' in the Size tab, and 'Relative to original picture size'). If you have dynamically linked, it's not necessary to call Excel from within Word, but open the source (xls) file. Then make the changes, and the Word document shd reflect them without changing the size of the table.

Henk57 jfox 07.02.08 7:19. Screwy workaround - I do a lot of this linking. Copy the cells (in excel) In word Paste speciallinkedas picture 'Will probably default to inline pic, I usually want floating Right clickFormat object'Size' tab 'In mine, it always pastes cells scaled at 98% height, 105% width, with charts, not a problem Uncheck 'Lock Aspect Ratio' Select 'OK' Right clickFormat object'Size' tab Change height to 100%, width to 100% Select 'OK' Right clickFormat object'Size' tab Check 'Lock Aspect Ratio' Select 'OK' You have to do these three steps discretely - and manually (I have had no luck changing these settings via VBA, except using sendkeys).

If you do these three, then you can go back in, adjust to whatever scale you need (say 90%/90%) and when updating the link, the size will not reset and go all screwy. Note: if you 'Change Source' via EditLinks you will have to repeat the above process. 8 months better late than never! Jan 09.09.08 15:19. Same thing is happening to me. I've read a lot of forums and tried some of the fixes, but nothing was working.

For some reason I began having the same problem with embedded excel sheets in MS Word docs that previously were working fine, so I began troubleshooting issues outside of MS Word/Excel. When I disconnected the laptop from the docking station and tested the embedded excel sheets, the tables reverted to normal. So, although I don't fully understand the root cause, it appears to be connected with display settings. Try adjusting display settings or disconnecting your laptop from the monitor and then open and close the embedded Excel sheet and see if that affects the distortion.

Cory.@gmail.com 04.01.18 1:19. Size matters於 2007年12月6日星期四 UTC+8下午1時14分00秒寫道： I suffered from the same problem for a long long time, and one day, I found a way to prevent this program happening: 1.

Microsoft Excel Worksheet Templates

Start MS-Word, 2. Go to Settings, go to Advanced Settings, write down these settings on a paper (or take screen snapshots); 3. Uncheck all these settings; 4. Re-start MS-Word; 5.

Retake all the settings you write down in step-2; Now you can use the Word as before, and the embedded Excel objects (Tables, Charts) will (hopefully) not re-size randomly anymore. It works in my environment and hope it works for you too. I can only conclude that it is a programming bug of Word, but hard to believe that Microsoft give no solution after so many complaints.

Hi, I made an Excel table, it is quite a big layout (A1:P74). Every time I copied this table and paste special to Word as an MS Excel Object (and resize it), there will be missing columns and/or rows. For example, my table contains data in row 74 and column P, but in Word only shows up to col N and row 73.

I can do fit to col and row in Excel and start over again but it will be a hassle if I have lots of tables. Is there any way to fix this?

Or is there other ways to copy a big excel table and paste it to Word and preserve the formats? Thanks a million. MrExcel.com debuted on November 21, 1998. MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

The Formulas, Functions and Visual Basic procedures on this web site are provided 'as is' and we do not guarantee that they can be used in all situations. This site contains affiliate links. Any affiliate commissions that we earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com running.

You can earn a commission for sales leads that you send to us by joining our. Excel ® is a registered trademark of the Microsoft Corporation.

MrExcel ® is a registered trademark of Tickling Keys, Inc. All contents © 1998 - 2018 MrExcel Publishing All rights reserved.