software

I'm using Excel 2003, and have used the on-line help, have followed the
instructions clearly. Yet at the end of it all Excel states that I'm unable
to use validation against data from other workbooks, yet I have followed the
instructions under the online help: Create a drop-down list from a range of
cells. I can create a drop-down list using data from the same worksheet,
HELP!!

Hello VFPguruExcelNovice,

Try this step-by-step tutorial:

www.contextures.com/xlDataVal05.html

I have 2003 and follow this works for me.

Post back if you are still having difficulties!

Judith

--
Hope this helpsquot;VFPguruExcelNovicequot; wrote:

gt; I'm using Excel 2003, and have used the on-line help, have followed the
gt; instructions clearly. Yet at the end of it all Excel states that I'm unable
gt; to use validation against data from other workbooks, yet I have followed the
gt; instructions under the online help: Create a drop-down list from a range of
gt; cells. I can create a drop-down list using data from the same worksheet,
gt; HELP!!

If the data is on another worksheet in the same workbook, you have to give
the target range a name (Insertgt;Namegt;Define...) and use that. In another
workbook, not possible I think.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;JudithJubileequot; gt; wrote in message
news
gt; Hello VFPguruExcelNovice,
gt;
gt; Try this step-by-step tutorial:
gt;
gt; www.contextures.com/xlDataVal05.html
gt;
gt; I have 2003 and follow this works for me.
gt;
gt; Post back if you are still having difficulties!
gt;
gt; Judith
gt;
gt; --
gt; Hope this helps
gt;
gt;
gt; quot;VFPguruExcelNovicequot; wrote:
gt;
gt; gt; I'm using Excel 2003, and have used the on-line help, have followed the
gt; gt; instructions clearly. Yet at the end of it all Excel states that I'm
unable
gt; gt; to use validation against data from other workbooks, yet I have followed
the
gt; gt; instructions under the online help: Create a drop-down list from a range
of
gt; gt; cells. I can create a drop-down list using data from the same worksheet,
gt; gt; HELP!!
Thankyou!

quot;VFPguruExcelNovicequot; wrote:

gt; I'm using Excel 2003, and have used the on-line help, have followed the
gt; instructions clearly. Yet at the end of it all Excel states that I'm unable
gt; to use validation against data from other workbooks, yet I have followed the
gt; instructions under the online help: Create a drop-down list from a range of
gt; cells. I can create a drop-down list using data from the same worksheet,
gt; HELP!!

gt;In another workbook, not possible I think.

Possible, but not worth the trouble.

You'd have to create the defined name in the target file and the source file
has to open.

Easier just to create the source in the current file.

Biff

quot;Bob Phillipsquot; gt; wrote in message
...
gt; If the data is on another worksheet in the same workbook, you have to give
gt; the target range a name (Insertgt;Namegt;Define...) and use that. In another
gt; workbook, not possible I think.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;JudithJubileequot; gt; wrote in message
gt; news
gt;gt; Hello VFPguruExcelNovice,
gt;gt;
gt;gt; Try this step-by-step tutorial:
gt;gt;
gt;gt; www.contextures.com/xlDataVal05.html
gt;gt;
gt;gt; I have 2003 and follow this works for me.
gt;gt;
gt;gt; Post back if you are still having difficulties!
gt;gt;
gt;gt; Judith
gt;gt;
gt;gt; --
gt;gt; Hope this helps
gt;gt;
gt;gt;
gt;gt; quot;VFPguruExcelNovicequot; wrote:
gt;gt;
gt;gt; gt; I'm using Excel 2003, and have used the on-line help, have followed the
gt;gt; gt; instructions clearly. Yet at the end of it all Excel states that I'm
gt; unable
gt;gt; gt; to use validation against data from other workbooks, yet I have
gt;gt; gt; followed
gt; the
gt;gt; gt; instructions under the online help: Create a drop-down list from a
gt;gt; gt; range
gt; of
gt;gt; gt; cells. I can create a drop-down list using data from the same
gt;gt; gt; worksheet,
gt;gt; gt; HELP!!
gt;
gt;