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

coryieong -- what are the settings? There's no picture or description of anything!

Originally Posted by

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.

djkalil53, what are the settings? There's no picture or description of them

Originally Posted by

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!

I have dealt with this issue for years, no solution.

It is not the "inline" setting, "lock aspect ratio" or any other setting I can find. And it has nothing to do with external monitors or display.

Still unfixed for me.

On Thursday, 11 June 2020 23:06:06 UTC+1, wrote:
I have dealt with this issue for years, no solution.

It is not the "inline" setting, "lock aspect ratio" or any other setting I can find. And it has nothing to do with external monitors or display.

Still unfixed for me.

Disconnecting the external monitor immediately solved it for me.

Right click then go to picture. In the format object set up go to size and picture tab and click reset. On Layout, click in line with text. It should return to its normal size.

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.


Why did this work?! Amazing. Thank you for this.

What are the settings to uncheck? I don't see anything on that part. Thank you very much.

On Thursday, October 29, 2020 at 10:02:59 AM UTC-6, Stefanie F wrote:
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.
Why did this work?! Amazing. Thank you for this.

What settings did you uncheck? I don't see that here. Thank you!

On Thursday, October 29, 2020 at 10:02:59 AM UTC-6, Stefanie F wrote:
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.
Why did this work?! Amazing. Thank you for this.