Hi and thanks for any help you can provide,
I upgraded from Office 2003 to 2010 in January and have had a reoccuring issue when trying to link from excel to word. I have a report that I run for work that I use to (with 2003) be able to punch in a few numbers and the word file would update itself and be good to go, since upgrading to 2010 it has been a mess, whenever I update word it adds extra lines before and after each place I have a cell being linked into word, creating an awfuly ugly document and one that I have to go delete tons of lines in, it's like excel is hitting enter before and after it pulls a cell value. If I have the word file open and click on a tab in the excel book that I has all the linked cells word updates and adds all the spaces back.
Is there a setting I am missing that is adding these lines? Any help would be much appreciated. The only thing I haven't done yet is completely re-create the word document as that would take a lot of time.
Thanks!
-Zach
I upgraded from Office 2003 to 2010 in January and have had a reoccuring issue when trying to link from excel to word. I have a report that I run for work that I use to (with 2003) be able to punch in a few numbers and the word file would update itself and be good to go, since upgrading to 2010 it has been a mess, whenever I update word it adds extra lines before and after each place I have a cell being linked into word, creating an awfuly ugly document and one that I have to go delete tons of lines in, it's like excel is hitting enter before and after it pulls a cell value. If I have the word file open and click on a tab in the excel book that I has all the linked cells word updates and adds all the spaces back.
Is there a setting I am missing that is adding these lines? Any help would be much appreciated. The only thing I haven't done yet is completely re-create the word document as that would take a lot of time.
Thanks!
-Zach
