Last post Jan 18, 2012 03:53 AM by Qi Wu - MSFT
Jan 15, 2012 10:35 PM|jandizon|LINK
How should I generate an Excel File with this rule?
Should not be able to paste an invalid value to a validated cell from other worksheet.
Jan 18, 2012 03:53 AM|Qi Wu - MSFT|LINK
You may want to generate an excel file with the validate cell empty. If so, you can use the Open XML SDK to do it. You can modifying validate cell value like below :
If it doesn’t work you may clarify your problem.