Problems Creating Excel Tables in Word 2004

[gbhawkins]

I am used to using Word 2007 where you can create a spreadsheet
directly in word without having to do so outside and insert it. It is
very easy, seamless and immediately. Word 2004 it is much more
involved. Is there any simple way I can create spreadsheets directly
in my word 2004 document like I do in the windows version? The way it
appears you have to do it- create the spreadsheet then insert is much
more time consuming.

I have to use lots of spreadsheets throughout documents to do
elaborate calculations and why tables are no good. Also, I want to
avoid having to create an excel item and then cut and paste it as I do
not have to do this with ooffice 2007 for windows. In that windows
version there is a button on the word toolbar, I click it and its
immediately inserts a blank spreadsheet IN the document and when I
modify it it is in the document and stays with it. I resize it, modify
it, etc., in the document, which is much easier, much faster, etc.

However, with Word 2004, I have to create a spreadsheet outside a
document and save it and then insert it, or copy it and paste it.
These extra steps may not sound like much, but it is one fourth as
fast as I can with Word 2007 or 2003. I want to use and move to the
MAC and am trying to figure out if there is a way to do this
similarly. If not, I may just have to park the MacBook Pro until the
new office 2008 comes out in the fall and hope it has a similar
capability. The other option I have is to use Parallels and Office
2007. I have done that and it works fine, but it involves a little
hassle.

Any ideas appreciated as I want to move permanently to the Mac.

 

[CyberTaz]

Is this a request for assistance or just a rant

You might prefer to use Insert>Object - Excel Worksheet [wording may be
different] which provides the same functionality. I can't remember if there
is a default button on the toolbar or not - am not a my Mac right now. (It
may be "hidden" in the additional buttons disclosed when you click the right
end of the Standard toolbar.) If there isn't you can certainly add one
through the Tools>Customize features.

You'll also find that Office 2004 is more directly comparable to Office 2003
on the PC rather than Office 2007... which isn't directly comparable to
Office 2003 either

 

[CyberTaz]

Just a follow-up after having verified - the button is exactly where I
remembered it... Fancy that Click the black triangle at the right end of
the Standard toolbar to open a list of additional buttons. It's there as
Insert Excel Spreadsheet.

I should mention, though, that the process is handled a bit differently
because of the distinctions between Windows & OS X. It may take a little
"getting used to" but I doubt it will be a problem. When you click the
button Excel will launch & you can do your work exactly as though you were
in Excel - after all, you are. However, when you close the worksheet you
return to Word & your work will be embedded in the doc as an object. At the
same time, the instance of Excel will close if you close the sheet, itself.

Also, when you want to edit the sheet, just double-click it as you would in
PC Word, but the sheet will open in Excel rather than as a window in the
doc. Your changes, however, will appear in the doc object when you close the
sheet. You can also Command-Tab back & forth between Word & the instance of
Excel without having to close & reopen the sheet if you're going to be
making further changes.

Further, a sheet created this way is *not* saved as a separate Excel file,
although you do have the option to do so if you wish - while the object is
open in Excel use the File>Save Copy As command.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[John McGhie]

That's a new function in Word 2007. Wait for Word 2008 on the Mac and it
will probably be there.

I am used to using Word 2007 where you can create a spreadsheet
directly in word without having to do so outside and insert it. It is
very easy, seamless and immediately. Word 2004 it is much more
involved. Is there any simple way I can create spreadsheets directly
in my word 2004 document like I do in the windows version? The way it
appears you have to do it- create the spreadsheet then insert is much
more time consuming.

I have to use lots of spreadsheets throughout documents to do
elaborate calculations and why tables are no good. Also, I want to
avoid having to create an excel item and then cut and paste it as I do
not have to do this with ooffice 2007 for windows. In that windows
version there is a button on the word toolbar, I click it and its
immediately inserts a blank spreadsheet IN the document and when I
modify it it is in the document and stays with it. I resize it, modify
it, etc., in the document, which is much easier, much faster, etc.

However, with Word 2004, I have to create a spreadsheet outside a
document and save it and then insert it, or copy it and paste it.
These extra steps may not sound like much, but it is one fourth as
fast as I can with Word 2007 or 2003. I want to use and move to the
MAC and am trying to figure out if there is a way to do this
similarly. If not, I may just have to park the MacBook Pro until the
new office 2008 comes out in the fall and hope it has a similar
capability. The other option I have is to use Parallels and Office
2007. I have done that and it works fine, but it involves a little
hassle.

Any ideas appreciated as I want to move permanently to the Mac.

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Sydney, Australia. S33°53'34.20 E151°14'54.50
+61 4 1209 1410, mailto:[email protected]

 

[Elliott Roper]

Going on from Bob's post about the toolbar button for inserting Excel
sheets. You can get there using the Insert » Object... menu too. That
means you can record a macro and assign it to a keystroke. That would
give the exact function you seek.

 

[John McGhie]

Hi Elliot:

Yeah, but that's not the function he wants. In Word 2007, they manage to
hide the fact that it is an "insertion". You actually get a new blank
spreadsheet in your Word document.

It's the same mechanism, it's just a lot nicer to use in Office 2007.

Cheers

Going on from Bob's post about the toolbar button for inserting Excel
sheets. You can get there using the Insert » Object... menu too. That
means you can record a macro and assign it to a keystroke. That would
give the exact function you seek.

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Sydney, Australia. S33°53'34.20 E151°14'54.50
+61 4 1209 1410, mailto:[email protected]

 

[John McGhie]

Yeah, you're right, I too had forgotten how saintly you are. Can't think
why...

Top posters are nice people too

Oh all *right*! I need one keystroke (the macro) to get a fresh
spreadsheet, and one keystroke (cmd-tab) to disappear the Excel and be
back editing in Word with the insertion point positioned *just* so.

I gotta love this group. Whenever I think I'm being curmudgeonly and
pedantic, I only have to read a couple of posts in here to realise how
saintly I am.

Why I *really* like it, is that without thinking about this question I
would still be cutting and pasting Excel snippets. GBHawkins, I thank
you!


I *still* hate top posting.

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Sydney, Australia. S33°53'34.20 E151°14'54.50
+61 4 1209 1410, mailto:[email protected]

 

[Phillip Jones]

Yeah, you're right, I too had forgotten how saintly you are. Can't think
why...

Top posters are nice people too

Glad to hear we are.

Seems far more logical in support context that top posting be used.

That way you get to the most current answer, and don't have to spend
time wasting, scrolling 10 thousand previous line to get to the most
recent proposed answer or comment. even clicking in the bottom scroll
triangle if there are very many replies still waste time.

Now if your carrying on a normal conversation say like reading a letter
Bottom posting should be the rule.

It takes me anywhere from 10 to 30 seconds more per subject on a
newsgroup to read post and replies on a Bottom posted newsgroup than a
top posted group. If All the newsgroups I read during the day bottom
post I would be on computer from 7 in morning to 11 at night with no
rest for bathroom breaks or to eat. As it stands now I can get through
in about half a day.


--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>