limit on #excel columns in word

[gbhawkins]

A bug in word 2004 is that an excel spreadsheet in the document has a
limit of 5 columns and a limit on the number of rows. Is there any
workaround on this limit? I need to use active spreadsheets in word
documents- there is no such limit in the windows version. Help is
appreciated.

 

[JE McGimpsey]

A bug in word 2004 is that an excel spreadsheet in the document has a
limit of 5 columns and a limit on the number of rows. Is there any
workaround on this limit? I need to use active spreadsheets in word
documents- there is no such limit in the windows version. Help is
appreciated.

Not sure what you mean - I just imported an 11-column worksheet into
Word...

 

[gbhawkins]

You imported a worksheet into Excel. That is what I do not want to
have to do. I want to actually create the spreadsheets in word
directly, which is what is very easy to do in the windows version of
word without the row and columns limit. You can create a spreadsheet
directly in excel (and can do it in the MAC version of word also) and
avoid the extra steps you are having to create it outside, then import
it. I have documents with large numbers of spreadsheets in them.

 

[gbhawkins]

Said another way, if you use the Insert >Object>New Excel Spreadsheet
command to create a spreadsheet directly in word it has a limit of
five columns. Microsoft acknowledges it as bug. I am wondering if
there is a workaround on the limit, but still be able to create
spreadsheets directly in word.

 

[gbhawkins]

Thanks much. Right now I am using office 2007 in parallels because of
this limitation, but was hoping to get around the issue to go fully
Mac. Hopefully, Office 2008 for the mac will be out in several months
without this flaw.

 

[JE McGimpsey]

You imported a worksheet into Excel. That is what I do not want to
have to do. I want to actually create the spreadsheets in word
directly, which is what is very easy to do in the windows version of
word without the row and columns limit. You can create a spreadsheet
directly in excel (and can do it in the MAC version of word also) and
avoid the extra steps you are having to create it outside, then import
it. I have documents with large numbers of spreadsheets in them.

Ah. Have to say that in all my twenty-three years of working with XL and
Word on a Mac, I have NEVER used Word to create an XL object. Just would
never even have occured to me. Hmmm...very bizarre bug.

As a workaround, one could certainly create a VBA macro or an
AppleScript to open XL, save a temporary file, import it into Word and
then delete the file and close XL. Wouldn't take but a moment to
execute, assuming you don't have a lot of startup macros in XL.

In addition to giving you more columns/rows, it would allow you to
format the default embedded sheet any way you want.