I need formula in excel spreadsheet to work in multple word pages

  • Thread starter Thread starter philber
  • Start date Start date
P

philber

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
 
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
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
 
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
 
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
thank you, have a great day.

Graham Mayor said:
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Click to expand...
 
Hi Graham

i have done a paste special and have the excel spreadsheet in word. The
gridlines show on screen but do not print
 
Gridlines don't print. You need cell borders to have the cell outlines
print.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
ok thanks

Graham Mayor said:
Gridlines don't print. You need cell borders to have the cell outlines
print.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

forms, data import excel, generate multiple pages 2
Working with Excel worksheet in Word document 1
Alt codes 4
Resize linked Excel spreadsheet within Word 1
Microsoft Works to Microsoft Office 6
Formatting of excel worksheets in word 2
lose format when linking excel to work 1
excel spreadsheet in word, gridlines don't print 1

Back
Top