ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Inserting a MS Word object into an Excel spreadsheet (2 questions) (https://www.excelbanter.com/excel-worksheet-functions/170690-inserting-ms-word-object-into-excel-spreadsheet-2-questions.html)

Phrank

Inserting a MS Word object into an Excel spreadsheet (2 questions)
 
First question: I'm trying to insert an object (MS Word document)
into an Excel spreadsheet of a shared workbook. The Word document is
2 pages, but the inserted object only displays the first page. How
can I get it to show both pages?

2nd question: I'm trying to have this shared workbook open.
automatically update links, and not display the startup prompt. After
checking the Help file, I learned that I needed to:

1. On Edit menu, click Links.
2. Click Startup Prompt.
3. Select the option you want.

I've done this, and I selected the option: "Don't display the alert
and update the links". However, every time I open the file, the alert
still displays. How do I get it to stick?

Also, I know I can go to ToolsOptionsEdit and uncheck the box "Ask
to update automatic links", but the help file says this is only for
the current user, and I want this link to be updated for all users and
no alert to show. Thanks for any help.

Frank

ryguy7272

Inserting a MS Word object into an Excel spreadsheet (2 questions)
 
I can't tell exactly what you are doing, but I've use this technique and had
great success with it:

http://word.mvps.org/FAQs/InterDev/C...WordFromXL.htm


Regards,
Ryan---


--
RyGuy


"Phrank" wrote:

First question: I'm trying to insert an object (MS Word document)
into an Excel spreadsheet of a shared workbook. The Word document is
2 pages, but the inserted object only displays the first page. How
can I get it to show both pages?

2nd question: I'm trying to have this shared workbook open.
automatically update links, and not display the startup prompt. After
checking the Help file, I learned that I needed to:

1. On Edit menu, click Links.
2. Click Startup Prompt.
3. Select the option you want.

I've done this, and I selected the option: "Don't display the alert
and update the links". However, every time I open the file, the alert
still displays. How do I get it to stick?

Also, I know I can go to ToolsOptionsEdit and uncheck the box "Ask
to update automatic links", but the help file says this is only for
the current user, and I want this link to be updated for all users and
no alert to show. Thanks for any help.

Frank



All times are GMT +1. The time now is 06:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com