Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
I need formula in excel spreadsheet to work in multple word pages
I am doing a paste special from excel to word. the spreadsheet spans several
pages and I need the formulas to work through all of them |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
I need formula in excel spreadsheet to work in multple word pages
Use edit paste special html format with the 'link' box checked. Any
changes you make in the sheet should be immediately transferred when both the document and the sheet are open, or when the link is updated otherwise. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org philber wrote: I am doing a paste special from excel to word. the spreadsheet spans several pages and I need the formulas to work through all of them |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
I need formula in excel spreadsheet to work in multple word pa
It isn't the answer unfortunately. I need to be able to manipulate the excel
spreadsheet within word so if I change numbers on page 1 the total filters through to subsequent pages. I am not concerned about changing the formula in excel and it reflecting in the spreadsheet in word. Hope you have the answer Graham Thank you "Graham Mayor" wrote: Use edit paste special html format with the 'link' box checked. Any changes you make in the sheet should be immediately transferred when both the document and the sheet are open, or when the link is updated otherwise. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org philber wrote: I am doing a paste special from excel to word. the spreadsheet spans several pages and I need the formulas to work through all of them |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
I need formula in excel spreadsheet to work in multple word pa
Perhaps I spoke too soon, it does function the way you have said. Is there a
way to simplify so I can double click on the table one one page in word, modify the number on that page and have the formulas filter through to other pages, even though I have not opened the tables on the other pages. Thank you "Graham Mayor" wrote: Use edit paste special html format with the 'link' box checked. Any changes you make in the sheet should be immediately transferred when both the document and the sheet are open, or when the link is updated otherwise. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org philber wrote: I am doing a paste special from excel to word. the spreadsheet spans several pages and I need the formulas to work through all of them |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
I need formula in excel spreadsheet to work in multple word pa
No - it only works from Excel.. Another possibility is to paste as an Excel
Worksheet Object. Such objects will not span pages and so you would have to paste manageable sized links. Double click the object to open Excel to make your changes. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org philber wrote: Perhaps I spoke too soon, it does function the way you have said. Is there a way to simplify so I can double click on the table one one page in word, modify the number on that page and have the formulas filter through to other pages, even though I have not opened the tables on the other pages. Thank you "Graham Mayor" wrote: Use edit paste special html format with the 'link' box checked. Any changes you make in the sheet should be immediately transferred when both the document and the sheet are open, or when the link is updated otherwise. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org philber wrote: I am doing a paste special from excel to word. the spreadsheet spans several pages and I need the formulas to work through all of them |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
I need formula in excel spreadsheet to work in multple word pa
thank you, have a great day.
"Graham Mayor" wrote: No - it only works from Excel.. Another possibility is to paste as an Excel Worksheet Object. Such objects will not span pages and so you would have to paste manageable sized links. Double click the object to open Excel to make your changes. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org philber wrote: Perhaps I spoke too soon, it does function the way you have said. Is there a way to simplify so I can double click on the table one one page in word, modify the number on that page and have the formulas filter through to other pages, even though I have not opened the tables on the other pages. Thank you "Graham Mayor" wrote: Use edit paste special html format with the 'link' box checked. Any changes you make in the sheet should be immediately transferred when both the document and the sheet are open, or when the link is updated otherwise. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org philber wrote: I am doing a paste special from excel to word. the spreadsheet spans several pages and I need the formulas to work through all of them |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
I need formula in excel spreadsheet to work in multple word pa
Hi Graham i have done a paste special and have the excel spreadsheet in word. The gridlines show on screen but do not print "Graham Mayor" wrote: Use edit paste special html format with the 'link' box checked. Any changes you make in the sheet should be immediately transferred when both the document and the sheet are open, or when the link is updated otherwise. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org philber wrote: I am doing a paste special from excel to word. the spreadsheet spans several pages and I need the formulas to work through all of them |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
I need formula in excel spreadsheet to work in multple word pa
Gridlines don't print. You need cell borders to have the cell outlines
print. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org philber wrote: Hi Graham i have done a paste special and have the excel spreadsheet in word. The gridlines show on screen but do not print "Graham Mayor" wrote: Use edit paste special html format with the 'link' box checked. Any changes you make in the sheet should be immediately transferred when both the document and the sheet are open, or when the link is updated otherwise. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org philber wrote: I am doing a paste special from excel to word. the spreadsheet spans several pages and I need the formulas to work through all of them |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
I need formula in excel spreadsheet to work in multple word pa
ok thanks
"Graham Mayor" wrote: Gridlines don't print. You need cell borders to have the cell outlines print. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org philber wrote: Hi Graham i have done a paste special and have the excel spreadsheet in word. The gridlines show on screen but do not print "Graham Mayor" wrote: Use edit paste special html format with the 'link' box checked. Any changes you make in the sheet should be immediately transferred when both the document and the sheet are open, or when the link is updated otherwise. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org philber wrote: I am doing a paste special from excel to word. the spreadsheet spans several pages and I need the formulas to work through all of them |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel spreadsheet to word | Microsoft Word Help | |||
Formula from Excel does not work with Word | Tables | |||
How can i print multple pages on one sheet of paper using Word? | Microsoft Word Help | |||
page numbering in Windows ME for multple pages | Microsoft Word Help | |||
How do I get a formula "=SUM(ABOVE)" to work in a protected WORD . | Microsoft Word Help |