TIP: Click on subject to list as thread! ANSI
echo: ms_word
to: LAUREN THOMSON
from: BOB DAVIS
date: 1997-03-01 09:19:00
subject: Totals in figure work

LT> figures, and do nice underline before the total and double
LT> underline under the total.
LT> How can the same thing be done satisfactorily in Word
LT> without touching excel?
In Word, use tables. The formula for total would be =sum(above). Then use 
borders to place a single underline above and double underline below the 
total.
You can produce the same results using borders in Excel. Excel even has a 
single button to do it in one click.
Embedding excel in Word has the advantage of being much easier to work with 
lots of numbers and equations. You also can format numbers easily in excel. I 
like to excerpt numbers from a master (complex) spreadsheet by linking. This 
way, I can update the master spreadsheet and the Word report is updated 
automatically. The disadvantage of the embedded spreadsheet is the overhead. 
The document is bigger and the operation is slower. I've found that OLE 
became useful with Office 95 and Windows 95 and a Pentium processor with 
ample memory. Before these, I considered OLE to be a techno-toy, rather than 
a useful work tool. These days, I use OLE extensively for embedding excel 
spreadsheets and visio drawings.
Bob
--- timEd/2-B11
---------------
* Origin: The Fireside BBS Houston TX (281)496-6319 (1:106/114)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.