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 19
Copy addition formula of non-consecutive horizontal cells 2
VLookup Won't Copy down (#REF! error) 1
#REF errors in links 0
Keeping references while changing worksheets 1
#REF! trying to white out 3
Diplaying results of a formula instead of the formula itself 1
Copy formula from one worksheet to another to get value in 2nd wks 2

Top