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 out as he was an Excel whiz. We've tried to copy and move to end- that somewhat worked but again- not all formulas are functioning and theres errors and REF# on alot. I think someone may have deleted a column which is why the REF# is on the sheets that are pulling info over. I have saved sheets from when he was here that I have tried going backwards on and copying but it still wont work. Im at my wits end! The #3 page should be talking to page #2 and it isnt- this is where we are stuck- HELP!
4 Replies
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.
Thank goodness I posted in a Microsoft Tech community and had over 20 people look at this and not ONE can give any type of an answer! smdh
Gina,
why don't you ask your former colleague? He knows how the formulas work.
Otherwise you have to learn how the formulas work:
I can even email the previous worksheet to someone if they are willing to help me. I just need it all copied (all pages) and sent back clean WITH all formulas in place. Anybody??
