Embed an open XLSM file in MS Word

[Nick]

We currently have Office 2007 Pro Plus, but when we try to embed an open XLSM
file, it embeds it as an Office 2003 document, thus truncating it down to
65536 rows. We have a file with more rows than that and would like to know
how to resolve this issue when someone tries to embed an Opened XLSM file
into Word 2007 and retain that it is an Excel 2007 file.

Note: Embedding the same Excel 2007 XLSM file while it is closed into Word
2007 embeds the file as a 2007 document with no issues. This may be a MS bug
so if there is no solution, I would like to know how to report this to them.

 

[Bob Buckland ?:-\)]

Hi Nick,

What are the steps you're following?

Do you have Office 2007 Service Pack 1 installed?

===================
We currently have Office 2007 Pro Plus, but when we try to embed an open XLSM
file, it embeds it as an Office 2003 document, thus truncating it down to
65536 rows. We have a file with more rows than that and would like to know
how to resolve this issue when someone tries to embed an Opened XLSM file
into Word 2007 and retain that it is an Excel 2007 file.

Note: Embedding the same Excel 2007 XLSM file while it is closed into Word
2007 embeds the file as a 2007 document with no issues. This may be a MS bug
so if there is no solution, I would like to know how to report this to them.

--
Nick >>
--

Bob Buckland ?
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*

 

[Nick]

We have a XLSM Excel 2007 document which has over 65536 rows, so any amount
over that would be okay, we open up this XLSM file and then proceed to embed
this same file into Word 2007.

Once Word is open and the XLSM is still open, click on the insert tab in
Word, Select object, click the create from file tab, browse to the open XLSM
file, check display as icon.

Yes we currently do have SP1 installed.

Thank you in advance for any help you can provide.

 

[Bob Buckland ?:-\)]

Hi Nick,

Hmmm. I can reproduce the problem in Word 2007 SP1 on both .xlsx and .xlsm files.

As you mentioned, when Excel 2007 is closed and you embed the Excel 2007 workbook set to display as icon the Word field (Alt+F9 to
display) becomes

{EMBED.Excel.Sheet.12} [for .xlsX]
or
{EMBED.Excel.SheetMacroEnabled.12} [for .xlsM

But, when the document is open in Excel 2007 the name of the file is correct, but Word throws it into compatibility mode as
{EMBED.Excel.Sheet.8}

Right click on the embedded display Icon and choosing 'convert' changes the field content (Alt+F9) to the correct looking wording
but doesn't seem to fix the underlying issue.

===============
We have a XLSM Excel 2007 document which has over 65536 rows, so any amount
over that would be okay, we open up this XLSM file and then proceed to embed
this same file into Word 2007.

Once Word is open and the XLSM is still open, click on the insert tab in
Word, Select object, click the create from file tab, browse to the open XLSM
file, check display as icon.

Yes we currently do have SP1 installed.

Thank you in advance for any help you can provide.
--
Nick >>
--

Bob Buckland ?
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*

 

[Nick]

Sounds like you are going through the same things that I did with the Alt+F9
and converting. Kinda good to hear that you have the same issue, but bad
that this problem still is an issue.

Do you know how to give this to MS to correct?

 

[Bob Buckland ?:-\)]

Hi Nick,

Microsoft is aware of this but no word back on any planned action yet.

=============
Sounds like you are going through the same things that I did with the Alt+F9
and converting. Kinda good to hear that you have the same issue, but bad
that this problem still is an issue.

Do you know how to give this to MS to correct?
--
Nick >>
--

Bob Buckland ?
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*

 

[Nick]

Thank you Bob for your help on getting this reported to MS.

Much appricieted.

 

[Nick]

Hi Bob,

Did MS give you a ticket # or Work Order # or something that we can use as
possible tracking to see the progress on this?

Thanks again for your help,

 

[Nick]

FYI.....Microsoft has determined this to be an issue and has been pushed up
to product support for analysis. No hotfix or service pack timeline was
given.

The workaround they gave was to make sure Excel is closed before embedding
the workbook into Word.