Opening Excel Files in Word

[avj]

I have done a custom install of Office 2003, running all options on my computer. When I try to open an Excel file from Word, In the Files of Type drop-down Excel isn't an option and if I choose All files and try to open the Excel file I receive a File Conversion Dialog box?

Any ideas what I need to do to correct that?

 

[Shauna Kelly]

Hi avj

You can't open an Excel file in Word in the same way you can open a Word
file in Word (or vice versa, for that matter).

To put an existing Excel file in a Word document, you can use Insert >
Object. Click on the Create from File tab, and choose your file.

Or, you can open the file in Excel, select a range and copy it, then in
Word, choose Edit > Paste Special and choose Microsoft Excel Worksheet
Object.

Hope this helps. If not, post back and tell us what you're trying to
achieve.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word

I have done a custom install of Office 2003, running all options on my

computer. When I try to open an Excel file from Word, In the Files of Type
drop-down Excel isn't an option and if I choose All files and try to open
the Excel file I receive a File Conversion Dialog box?

 

[Pat Garard]

G'Day avj,

Forgive my being direct, but the thing that needs to be
corrected is the idea-set in your head.

Microsoft Word is a program that has a focus on documents.
The documents can be Memos, Letters, Reports, FAXs,
e-Mails, Proposals (etc) and even entire books. The internal
file structure has been designed to do this (more or less) efficiently.

Microsoft Excel is a program that has a focus on spreadsheets.
The spreadsheets can be shopping lists, address lists, lists of
all kinds, Budget, Expenditure & Variance, Consolidation,
Experimental or Survey Results, Statistical analyses, Pivot
analysis and numerical analysis generally. Again the internal file
structure has been designed to do this (more or less) efficiently.

These internal file structures are quite different, and one of the
programs will NOT directly open a file created by the other.

Various methods have been established to include spreadsheet
data in documents (and vice versa).

I do hope this helps.
--
Regards,
Pat Garard
Australia

______________________________________

 

[avj]

In previous versions, when you click on the Open button, you could select Excel as a File type and then when you opened it, you'd receive an Open Worksheet Dialog box that would prompt you to open the Entire Workbook or a specific sheet in the workbook.

At home, I do not have the Excel option - but I'm running Windows XP home with Office 2003. At the school lab, we are running Windows 2000 Professional with Office 2003 and I believe I can do it from there with the same functionality I had with previous versions. Maybe it's a difference with the OS and not just an Office thing. I'll double check and post back...

Thanks,
avj

 

[Graham Mayor]

Actually Shauna and Pat are not quite correct on this matter - it was
possible to do this as you describe, but for reasons of security Microsoft
has removed (or modified) the text converter excel32.cnv which provided the
functionality. If you have access to a machine on which this still works,
then the old filter will still work, albeit with a security warning. Copy
the file excel32.cnv to the same TextConv folder on your home machine -
usually C:\Program Files\Common Files\Microsoft Shared\TextConv.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[avj]

Thanks, I'll try it...
avj

Actually Shauna and Pat are not quite correct on this matter - it was
possible to do this as you describe, but for reasons of security Microsoft
has removed (or modified) the text converter excel32.cnv which provided the
functionality. If you have access to a machine on which this still works,
then the old filter will still work, albeit with a security warning. Copy
the file excel32.cnv to the same TextConv folder on your home machine -
usually C:\Program Files\Common Files\Microsoft Shared\TextConv.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>