If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula addition causes random #REF!
I have added a new formula to ledger worksheets and now the #REF! appears in
areas in the workbook. In order to fix it, all I have to do is copy a good cell with the formula (one that isn't showing #REF!) to on that is showing #REF! and all the cells in the workbook clear up. Any suggestions please? Thank you -- stevew |
#2
|
|||
|
|||
Formula addition causes random #REF!
It would help if we could see the formula
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "stevew" wrote in message ... I have added a new formula to ledger worksheets and now the #REF! appears in areas in the workbook. In order to fix it, all I have to do is copy a good cell with the formula (one that isn't showing #REF!) to on that is showing #REF! and all the cells in the workbook clear up. Any suggestions please? Thank you -- stevew |
Thread Tools | |
Display Modes | |
|
|