View Single Post
  #5   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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