Forum Discussion
HELP! I need some expertise- we use a HUGE worksheet at work and the man that created it got fired
This worksheet has lots of big formulas and we have tried to copy the previous month over to use this month but they arent all working properly and I am stuck! No one here can figure it...
Unfortunately, you really haven't posted enough to go on. Can you see the (Hide) sheets? Have you tried auditing the formulas with the Evaluate tool (Formulas > Evaluate Formula)?
Regarding the REF errors, you'd need to know what's been deleted, so you'd probably want to revert to an older version that doesn't have them.
FYI - The formula in second example =IF('CommLog'!$B$2:$B$28=""...will never meet that test, as it's an invalid argument.
If this is business critical, and no one there can figure it out, I'd strongly suggest hiring an Excel consultant.