Hello,

I have a small business. I have made my own template for making bids. In a word document I have inserted an excel document where all addition, taxes and totals are automatically generated. In some cases, like larger projects, the excel document is larger than a printable page. When I insert it in the word document, everything below the last printable line is lost. Now I "solve" this problem by inserting the same excel document again on the next page, make everything invisible that is already showing on the former page, so that it looks like the document continues. But in actual fact are two seperate ones.

The problem arises when I edit one of them. The other one will not automatically be changed as well. Sometimes this screws up additions and such. It's not very professional...

Any ideas?



Thanks a bunch!

Menno

The issue you're having is that an Excel object cannot span a page boundary. What you could do, though, is resize the Excel object so that it continues to fit the page. The alternative is to use a Word table, which can span a page boundary.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks, the resizing option is not practical, since the table would, in most cases, be illegible. The fontsize would become too small.

The Word table sounds interesting, but can it do the same calculations as Excel?

Thanks for your help!

Menno

I think i may have come up with a practical way around my problem. I make the document like before, so with the excel doc inserted. I save it as a base document, so I can later edit it. Then I select all the relevant cells and copy them into a one cell table (one column, one row) that is as wide as the whole page. It will then be pasted across the whole width of the page, and also continue logically to the next page(s). That doc will be sent to the potential clients. If I later need to edit the doc, I will simply edit the base doc and make a new client doc from there.

While Word can do even complex calculations, they're far less straightforward than using Excel.

To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial: https://www.msofficeforums.com/word/...-tutorial.html

To see how to do just about every date-based calculation you might want to in Word, check out my Microsoft Word Date Calculation Tutorial: https://www.msofficeforums.com/word/...-tutorial.html
Do read the document's introductory material.

A better solution, though, might be to use an external workbook for the calculations, then link that to your Word document (i.e. copy the Excel data, then use Paste Special>Paste Link. Linking provides a number of display formats you can choose from and allows you to keep the document up to date with changes in the workbook.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

thanks a lot, I will definitely check it out. Interesting stuff!