Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 11th 05, 10:09 PM
Fishyken
 
Posts: n/a
Default Excel: Use a name with external workbook reference for data valida

In Excel (2003), I am using Data Validation to create a drop down list. I
followed the instructions on "Create a drop-down list" in the help file.

I want to use a Name in the workbook as the Source for the list. First, I
defined the Name in my workbook to refer to a list/range in an external
workbook (as instructed on the help file "How?" link under "If you type the
list in a different workbook, define a name with an external reference to the
list.")

I then followed the remaining instructions for using a list for Data
Validation.

When I entered the Name as my Source for Data Validation, it returns the
following error message: "You cannot use a reference to another worksheet or
workbook for data validation criteria." Again, the Name that I am using is
defined within the worksheet that I want to use, but it refers to data in an
external workbook.




  #2   Report Post  
Old March 11th 05, 10:21 PM
Fishyken
 
Posts: n/a
Default

Please disregard this post; I found my answer in a reply to a post by
"Sampath" on 1/8/2005 with the same problem.

"Fishyken" wrote:

In Excel (2003), I am using Data Validation to create a drop down list. I
followed the instructions on "Create a drop-down list" in the help file.

I want to use a Name in the workbook as the Source for the list. First, I
defined the Name in my workbook to refer to a list/range in an external
workbook (as instructed on the help file "How?" link under "If you type the
list in a different workbook, define a name with an external reference to the
list.")

I then followed the remaining instructions for using a list for Data
Validation.

When I entered the Name as my Source for Data Validation, it returns the
following error message: "You cannot use a reference to another worksheet or
workbook for data validation criteria." Again, the Name that I am using is
defined within the worksheet that I want to use, but it refers to data in an
external workbook.



  #3   Report Post  
Old March 11th 05, 10:23 PM
Dave Peterson
 
Posts: n/a
Default

Maybe reading Debra Dalgleish's instructions will help:
http://www.contextures.com/xlDataVal05.html


Fishyken wrote:

In Excel (2003), I am using Data Validation to create a drop down list. I
followed the instructions on "Create a drop-down list" in the help file.

I want to use a Name in the workbook as the Source for the list. First, I
defined the Name in my workbook to refer to a list/range in an external
workbook (as instructed on the help file "How?" link under "If you type the
list in a different workbook, define a name with an external reference to the
list.")

I then followed the remaining instructions for using a list for Data
Validation.

When I entered the Name as my Source for Data Validation, it returns the
following error message: "You cannot use a reference to another worksheet or
workbook for data validation criteria." Again, the Name that I am using is
defined within the worksheet that I want to use, but it refers to data in an
external workbook.


--

Dave Peterson
  #4   Report Post  
Old March 11th 05, 10:24 PM
Dave Peterson
 
Posts: n/a
Default

Too late!

Fishyken wrote:

Please disregard this post; I found my answer in a reply to a post by
"Sampath" on 1/8/2005 with the same problem.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) Hari Prasadh Charts and Charting in Excel 4 February 17th 05 02:44 PM
How do I reference external data from a file, file name found in . Clux Excel Discussion (Misc queries) 1 February 10th 05 10:52 PM
How do I remove external links from Excel 2000 workbook? mlwest Excel Discussion (Misc queries) 2 February 4th 05 10:52 PM
Excel workbook crashed Edgar Thoemmes Excel Worksheet Functions 3 January 21st 05 12:36 PM
Why do I get a warning when I try to save an Excel 2003 workbook. David Williams Excel Discussion (Misc queries) 0 January 11th 05 07:59 PM


All times are GMT +1. The time now is 07:05 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017