PC Review


Reply
Thread Tools Rate Thread

Data validated list not transferring to Word - excel sheet

 
 
Imp14
Guest
Posts: n/a
 
      19th Nov 2009
I am having an issue inserting a table created in excel into a word document.

I have tried inserting and copying info from the excel spreadsheet into the
word document and although the columns, text, fill colours and even the list
tab on each cell transfers. However when you click on the cell and press the
list tab the list opens but there is no text to choose from.

I had created the list for each cell with Data Validation; naming each list
and inputting this info into {Data validation - Settings - Source
(=FFESpend)}.

The list options work whilst in excel however when I transfer the cells into
the word document in to the excel sheet the cells have the list option tab
however none of the text options on the list transfer.

Any help in getting these lists to work in the word doc appreciated.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transferring Excel Data to Word...??? Help, ASAP!!! breezemagic101 Microsoft Excel Misc 2 25th Jan 2010 07:23 AM
Macro for transferring data from excel to word Ajay Microsoft Excel Discussion 1 8th Jan 2009 09:53 PM
Transferring Word table data to Excel sheet Rajendra Microsoft Excel Programming 0 23rd Nov 2005 04:37 AM
Transferring Excel Data to Word Document maacmaac Microsoft Excel Misc 0 6th Oct 2005 05:23 PM
Sheet protection disables comments in data validated cells Andy Brown Microsoft Excel Misc 5 4th Aug 2003 06:39 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:31 AM.