Perform data validation from table on different worksheet in Excel 2007
Fresh3 days ago
Mar 15, 20267323 viewsConfidence Score0%
0%
Problem
Is it true that in Excel 2007 you can't do list validation to a table on a different worksheet, only a named range that is not a table? I enter a Source of and it keeps complaining "The formula you typed contains an error." On the worksheet where the table is, I click into the table, go to the Desi…
Error Output
=Responses
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Perform data validation from table on different worksheet in Excel 2007
Low Risk
Um... Yes and no. It's true that you can't create a list-based data validation field based on a column from a table. HOWEVER... You can use Name Manager to define a named range, and use it to point to a column in a table. EXAMPLE: I have a workbook …
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix