+ Reply to Thread
Results 1 to 2 of 2

Embed and retain dynamic Excel features in Word

  1. #1
    Registered User
    Join Date
    01-28-2022
    Location
    US
    MS-Off Ver
    Excel 2013
    Posts
    1

    Embed and retain dynamic Excel features in Word

    Hello,
    I have a set of cells in an Excel worksheet that includes 2 drop down lists along with a formula cell that creates a hyperlink based on the selections made in the drop down lists. I want to embed this into a Word document but every insert option I try in Word creates a version of the worksheet that cannot be interacted with i.e the drop down lists do not work and the hyperlink does not work. Does anyone know how to embed an Excel worksheet in Word and maintain its dynamic cell functions? Thank you in advance for any help you can provide.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Embed and retain dynamic Excel features in Word

    Dropdowns and hyperlinks in an embedded/linked Excel workbook remain active. You do, of course, have to activate the embedded/linked workbook before you can access the dropdowns/hyperlinks.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Embed read-only PDF/Word Doc into Excel worksheet
    By yankeesrus07 in forum Excel General
    Replies: 3
    Last Post: 08-03-2018, 08:54 AM
  2. Embed Word Doc into Excel
    By communistflamingo in forum Excel General
    Replies: 1
    Last Post: 01-08-2015, 09:21 AM
  3. Replies: 0
    Last Post: 07-16-2007, 06:11 PM
  4. [SOLVED] Embed Word doc. into Excel
    By HotRod in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2006, 11:53 AM
  5. [SOLVED] what three features in word,excel and powerpoint have n common?
    By collegemom2005 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-11-2005, 05:05 PM
  6. Embed Functional Word into Excel
    By Kent in forum Excel General
    Replies: 0
    Last Post: 02-02-2005, 08:20 PM
  7. Replies: 0
    Last Post: 02-02-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1