Hi all,
I have run into something that is causing me great difficullty. I have copied a worksheet from one workbook into another. It has cells linked to another sheet "POEOTO" for data validation list that is in both workbooks. But nothing appears in the drop down for the list. The data validation shows it references to =POEOTO. When I try to fix it by entering =EOPOTO for the data reference I get "You cannot use references to other worksheets or workbooks for Data Valdation criteria."
Is the copied worksheet still inked to the old workbook? If so how do I break taht link?
Thanks