Updating excel having formula
I want to update some cells in excel sheet. The cells contain formula. On executing the update query it is throwing error 'Cannot update (expression); field not updateable'.
Is there any way, by which I can update the columns containg the formula.(I've to use sqlquey)
Re: Updating excel having formula
Per this resource-
you will find that you can't use ADO to update a cell containing a formula since it is read only.