can we compare the formulas (not value) in two excel 2007 workbooks

I guess it depends on what you are trying to do. It could be done with VBA or it could be done by letting both formulas evaluate the same input and see if you get the same answer.

What exactly are you trying to do?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Hi, I am trying to know whether any changes made accidentally or by pressing of key in the formulas of the excel work book. For eg: if a enter data with the formula in workbook, I save and copy to another workbook to enter the data only so that , if somebody if accidentally delete the formula or cut the dependents of a formula, there will be some result which would not be correct. So, I want to see first whether any changes made in the formula so that vouchsafe the work book. I hope the forum understands.

Instead of checking for differences why don't you protect the cells that you don't want the users to change? To try and check for formula differences and/or if dependents have changed would require VBA code with very specifics requirements and could be quite intricate depending on how many things need to be checked.

I would use Data Validation or some of Excel's built in Protection features.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Sir, I have not received the best answer.I know there are softwares such as excel compare etc are doing rounds for these type of problems on a huge scale. I want a solution to my query. The protection is a known alternative, but this could not be expected if some body in the supervisory position is trying to proctect cells .Is there a solution of how to compare the formulas in two selected columns in excel 2007 at least. I do not know how to extend my question, and as I have not received the best answer to my query, I have not set best answer for my question. Thanking you

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History