Formula addition causes random #REF!

S

stevew

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
 

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

Similar Threads

Id'ing tabs that contain #REF!'s 16
how to find #ref! invalid cell references within cell formula 6
Excel Sumproduct Ref error when table is closed 0
#REF error in named formula 2
#REF! Error Resolve? 2
got #REF! with fomula PRICE() 2
#REF error! 7
#REF! trying to white out 3

Top