Excel Spreadsheet in Word Document

[Joe McGuire]

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!

 

[JoAnn Paules]

Is thre a reason why you don't use an Excel-based expense report? That's
what we use at work.

 

[Suzanne S. Barnhill]

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

 

[CyberTaz]

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

 

[Joe McGuire]

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

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]

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

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

 

[Joe McGuire]

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.