Formula Result Displays Incorrectly

L

LeRoy

In one sheet I have formulas linked to another sheet in the same workbook.
When I update the values in the source cells, the dependant cell values do
not change.

The workbook is set for automatic calculation. Even when I perform a forced
manual recalculation the cells continue to display incorrect results. The
only way I've been able to get the correct result is to delete and retype the
equal sign at the beginning of each formula in question.

Note: this error usually occurs when I have a large workbook with many
formulas.

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top