[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!

--
Joe McGuire

[JoAnn Paules]

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

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

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

[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



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!

[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
"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

[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
"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

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

--

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!