Microsoft Office Forums Table larger than a page from excel

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2015, 04:28 AM
FightinWindmills FightinWindmills is offline Table larger than a page from excel Windows 10 Table larger than a page from excel Office 2007
Novice
Table larger than a page from excel
 
Join Date: Oct 2015
Posts: 4
FightinWindmills is on a distinguished road
Default Table larger than a page from excel

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
Reply With Quote
  #2  
Old 10-18-2015, 01:00 PM
macropod's Avatar
macropod macropod is offline Table larger than a page from excel Windows 7 64bit Table larger than a page from excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,661
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 10-21-2015, 11:57 PM
FightinWindmills FightinWindmills is offline Table larger than a page from excel Windows 10 Table larger than a page from excel Office 2007
Novice
Table larger than a page from excel
 
Join Date: Oct 2015
Posts: 4
FightinWindmills is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 10-22-2015, 12:20 AM
FightinWindmills FightinWindmills is offline Table larger than a page from excel Windows 10 Table larger than a page from excel Office 2007
Novice
Table larger than a page from excel
 
Join Date: Oct 2015
Posts: 4
FightinWindmills is on a distinguished road
Default

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.
Reply With Quote
  #5  
Old 10-22-2015, 12:32 AM
macropod's Avatar
macropod macropod is offline Table larger than a page from excel Windows 7 64bit Table larger than a page from excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,661
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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, at:
http://windowssecrets.com/forums/sho...Maths-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party
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, at:
http://windowssecrets.com/forums/sho...ation-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party
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
[MS MVP - Word]
Reply With Quote
  #6  
Old 10-22-2015, 12:06 PM
FightinWindmills FightinWindmills is offline Table larger than a page from excel Windows 10 Table larger than a page from excel Office 2007
Novice
Table larger than a page from excel
 
Join Date: Oct 2015
Posts: 4
FightinWindmills is on a distinguished road
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to insert page break when copying Excel table into PP? How set headers/footers in PP like Word? proja PowerPoint 0 09-16-2015 12:36 PM
Table larger than a page from excel Importing Data from Excel - Format of table messed up in Word Table epsulliv Word Tables 6 08-24-2015 07:29 AM
Paginate table so cell headings appear top of page instead bottom page when no room bottom page mtcn Word Tables 5 12-11-2014 12:49 PM
How to change the path of a table copied by excel in word as linked table RTF? Cristin7 Word VBA 3 03-10-2014 05:25 AM
update one embedded excel table based on another excel table ajetrumpet Word 0 07-05-2013 08:51 PM


All times are GMT -7. The time now is 10:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft