LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 63
Default Remote Data Validation

What choices do we have to get around Excel's refusal to use a remote
workBOOK for cell data entry validation?

No problem to use another internal workSHEET when the range is named
but can't use an EXTERNAL workbook.

Could I perhaps use an internal hidden worksheet that obtained its
data from a remote workbook?
Still working on solutions.

Any ideas would be appreciated.

Dennis

 
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
custom data validation on cells with data validation values AKrobbins Excel Worksheet Functions 2 June 21st 11 04:20 PM
xlbgnm in remote data Bill Johnson[_2_] Excel Worksheet Functions 1 April 22nd 10 08:21 PM
read data in an excel file on a remote sever [email protected] Excel Programming 1 December 24th 06 07:34 AM
Remote data query stopped working Mark Scholes Excel Programming 0 February 24th 05 08:47 AM
remote data query and sum not working Sara Excel Worksheet Functions 0 November 4th 04 02:17 AM


All times are GMT +1. The time now is 06:23 AM.

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

About Us

"It's about Microsoft Excel"