Prev: Is there a function to solve for an unknown in an equation?
Next: Formula Help
From: stevew on 26 Apr 2010 12:31
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
From: Bernard Liengme on 26 Apr 2010 16:05
It would help if we could see the formula
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"stevew" <stevew(a)discussions.microsoft.com> wrote in message
news:55417FE1-DF79-4A05-8C64-B9FD19159F82(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Is there a function to solve for an unknown in an equation?
Next: Formula Help