Excel Worksheet Object resizes in Word when I edit/open it

Size matters於 2007年12月6日星期四 UTC+8下�1時14分00秒寫�：
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.

I suffered from the same problem for a long long time, and one day, I found a way to prevent this program happening:

1. 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.

Originally Posted by Size matters

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).
GoMovies
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.

I also have a similar problem. I searched a lot and tried some fixes but still don't work

On Thursday, January 4, 2018 at 2:19:15 AM UTC-7, wrote:
Size matters於 2007年12月6日星期四 UTC+8下�1時14分00秒寫�：
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.

I suffered from the same problem for a long long time, and one day, I found a way to prevent this program happening:

1. 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.

I am using Word 2016, and this workaround actually worked. Brilliant! I was working for several hours trying to figure out the "secret handshake." I should have Googled for an answer beforehand. Thanks!

On Wednesday, December 5, 2007 at 9:14:00 PM UTC-8, Size matters 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.

Holy Resurrection Batman! I found the 100% verifiable way to fix this from happening. The issue is from using the excel spreadsheet object as a floating object. It NEEDS to be set as an in-line with text object by Right clicking Format Object Layout Wrapping Style In line with text.

If you have issues with it jumping around pages, set the invisible lines to have a font size of 1pt and keep dragging it around until you get it "in-line" with the "text". Just keep in mind that the spreadsheet is now "technically" a text object so hitting backspace will delete it while typing.

On Thursday, December 6, 2007 at 12:14:00 PM UTC+7, Size matters 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.



all you nedd just save as your file with low version than your excel. example both initial files are MS Office 2019. after all work done, save as MS Word with old version. its work with me.

What are the settings at step 2? No images display here, and not one of them is written out. Please, I need this solution badly!

Nope, I've been putting an Excel object into a Word document as an in-line shape every time, and I still get the issue. It seems also related to whether you're using an external monitor?!?

https://answers.microsoft.com/en-us/...201337a?auth=1

What are the settings at step 2? They're not written anywhere, nor are any images displayed

stephen -- check this out:

https://answers.microsoft.com/en-us/...201337a?auth=1

I've been doing this as an inline shape from the beginning and always, and I still have zooming/resizing issues.

It seems to be related to external monitors?? Check this: https://answers.microsoft.com/en-us/...201337a?auth=1