Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel Worksheet Object resizes in Word when I edit/open it
|
#3
|
|||
|
|||
djkalil53, what are the settings? There's no picture or description of them
Quote:
|
#4
|
|||
|
|||
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!
|
#5
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel Worksheet Object resizes in Word when I edit/open it
What are the settings at step 2? They're not written anywhere, nor are any images displayed
|
#6
|
|||
|
|||
coryieong -- what are the settings? There's no picture or description of anything!
Quote:
|
#7
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel Worksheet Object resizes in Word when I edit/open it
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. |
#8
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel Worksheet Object resizes in Word when I edit/open it
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. |
#9
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel Worksheet Object resizes in Word when I edit/open it
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. |
#10
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel Worksheet Object resizes in Word when I edit/open it
What worked for me was right clicking the object (embedded from excel) and then scrolling over "Wrap text" and then clicking "square". Now when I save the document, the object does not automatically resize to be off the page.
On Thursday, October 29, 2020 at 3:51:58 PM UTC-7, Cody Gale, MAI, CCIM wrote: 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a Microsoft Office Excel Worksheet Object into Word | Microsoft Word Help | |||
Use an object linking to disply Excel worksheet data as a word tab | Tables | |||
how do I open and edit an excel worksheet | Microsoft Word Help | |||
edit inserted excel worksheet in word doc | Microsoft Word Help | |||
paste as EXCEL Worksheet Object | Formatting Long Documents |