Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel Worksheet Object resizes in Word when I edit/open it
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. 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 |
#2
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel Worksheet Object resizes in Word when I edit/open it
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. 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 |
#3
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel Worksheet Object resizes in Word when I edit/open it
The problem is not corrected with this. The next time the link is updated
the worksheet (object) is resized incorrectly again. I have tried many things and nothing seems to correct this problem. If you special paste the worksheet in as a metfile picture it doesn't resize but will not print borders and lines correctly. This worked previously in Word 2000 but does not work properly in 2003. Is this the case in 2007 too? "Henk57" wrote: 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. 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 |
#4
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel Worksheet Object resizes in Word when I edit/open it
Now do you know a way to center the spreadsheet between the margins without
using the centering option that appears to cause the resizing issue? Jfox "Henk57" wrote: 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. 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 |
#5
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel Worksheet Object resizes in Word when I edit/open it
Henk57 -
I stand corrected on my previous statement that your solution doesn't work. It does work if you keep the in line with text provision. Centering the spreadsheet seems to be the problem. It is not as pretty as when you can center the spreadsheet but it does keep Word from resizing the spreadsheet. Thanks for your information. jfox "Henk57" wrote: 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. 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 |
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 |