View Single Post
Old January 4th 18, 09:19 AM posted to microsoft.public.word.pagelayout
[email protected]
external usenet poster
Posts: 1
Default 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?

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.