Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Excel Spreadsheet in Word Document
Is there a way for me to put an Excel spreadsheet in a Word 2003 document
(actually a simple template for business travel expenses) and have it continue to operate as a spreadsheet? The closest I get is that my little excel spreadsheet goes into my Word document and becomes a table. And acts like one. That is, it will not add up the figures correctly in a column or row if any cell is left blank. Sure, a table would work if I just enter a bunch of zeroes where the blanks are. But I was thinking maybe a little more interoperability is possible. Is there a way to do this? Thanks! -- Joe McGuire |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Excel Spreadsheet in Word Document
Is thre a reason why you don't use an Excel-based expense report? That's
what we use at work. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Joe McGuire" wrote in message ... Is there a way for me to put an Excel spreadsheet in a Word 2003 document (actually a simple template for business travel expenses) and have it continue to operate as a spreadsheet? The closest I get is that my little excel spreadsheet goes into my Word document and becomes a table. And acts like one. That is, it will not add up the figures correctly in a column or row if any cell is left blank. Sure, a table would work if I just enter a bunch of zeroes where the blanks are. But I was thinking maybe a little more interoperability is possible. Is there a way to do this? Thanks! -- Joe McGuire |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Excel Spreadsheet in Word Document
You can embed an Excel object (no longer than a page, though, I think), but
you can still sum columns including blank cells if you use specific cell references instead of (Above). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Joe McGuire" wrote in message ... Is there a way for me to put an Excel spreadsheet in a Word 2003 document (actually a simple template for business travel expenses) and have it continue to operate as a spreadsheet? The closest I get is that my little excel spreadsheet goes into my Word document and becomes a table. And acts like one. That is, it will not add up the figures correctly in a column or row if any cell is left blank. Sure, a table would work if I just enter a bunch of zeroes where the blanks are. But I was thinking maybe a little more interoperability is possible. Is there a way to do this? Thanks! -- Joe McGuire |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Excel Spreadsheet in Word Document
Thanks. The document is principally an itinerary with all manner of travel
details, such as flight information, reservations, meeting plans, etc. The expense thing is just one part. -- Joe McGuire "JoAnn Paules" wrote in message ... Is thre a reason why you don't use an Excel-based expense report? That's what we use at work. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Joe McGuire" wrote in message ... Is there a way for me to put an Excel spreadsheet in a Word 2003 document (actually a simple template for business travel expenses) and have it continue to operate as a spreadsheet? The closest I get is that my little excel spreadsheet goes into my Word document and becomes a table. And acts like one. That is, it will not add up the figures correctly in a column or row if any cell is left blank. Sure, a table would work if I just enter a bunch of zeroes where the blanks are. But I was thinking maybe a little more interoperability is possible. Is there a way to do this? Thanks! -- Joe McGuire |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Excel Spreadsheet in Word Document
Thanks. The problem is that the cells that have a expense number in them
and those that have none will vary with each different document (the document is actually my itinerary with flight info, connections, busses, transit, hotels, meetings, etc.; the expense thing is just a part of it). Your suggestion would work if with each iteration of the document I revised the formula to specify which cells woud be used this time around. Just entering zeroes in the blanks would be a lot simpler. -- Joe McGuire "Suzanne S. Barnhill" wrote in message ... You can embed an Excel object (no longer than a page, though, I think), but you can still sum columns including blank cells if you use specific cell references instead of (Above). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Joe McGuire" wrote in message ... Is there a way for me to put an Excel spreadsheet in a Word 2003 document (actually a simple template for business travel expenses) and have it continue to operate as a spreadsheet? The closest I get is that my little excel spreadsheet goes into my Word document and becomes a table. And acts like one. That is, it will not add up the figures correctly in a column or row if any cell is left blank. Sure, a table would work if I just enter a bunch of zeroes where the blanks are. But I was thinking maybe a little more interoperability is possible. Is there a way to do this? Thanks! -- Joe McGuire |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Excel Spreadsheet in Word Document
Thanks. This would probably work if I actually had some Excel file/workbook
to link. What I have in my document--really a detailed itinerary for each business trip--for en expense summary IS the Excel spreadsheet or, more accurately, WAS the Excel spreadsheet I inserted into my Word document but now ismerely a table. -- Joe McGuire "CyberTaz" wrote in message .. . Use Insert Object Create from File or copy in Excel then Edit Paste Special MS Excel Worksheet into Word rather than a regular Paste. Either way you can also choose to Link to the Excel file so the embedded object can be updated based on changes in the workbook file & you can dbl-click the object in the Word doc to open it in Excel. HTH |:) Bob Jones [MVP] Office:Mac On 11/16/08 12:46 PM, in article , "Joe McGuire" wrote: Is there a way for me to put an Excel spreadsheet in a Word 2003 document (actually a simple template for business travel expenses) and have it continue to operate as a spreadsheet? The closest I get is that my little excel spreadsheet goes into my Word document and becomes a table. And acts like one. That is, it will not add up the figures correctly in a column or row if any cell is left blank. Sure, a table would work if I just enter a bunch of zeroes where the blanks are. But I was thinking maybe a little more interoperability is possible. Is there a way to do this? Thanks! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Word document to end of Excel spreadsheet | Page Layout | |||
How do I convert a WORD document to an EXCEL spreadsheet? | Microsoft Word Help | |||
Excel Spreadsheet within a Word Document | Microsoft Word Help | |||
excel spreadsheet to word document HOW? | Microsoft Word Help | |||
Formatting EXCEL spreadsheet onto WORD document | Page Layout |