Forum Discussion

null null's avatar
null null
Copper Contributor
Mar 24, 2018

Excel problems

Hi Excel Experts ,

 

Need your help urgently.

I am facing a technical issue for my new job. My direct boss kept on insisting her excel formula runs and data is not accurate. She created her multiple spreadsheets in a shared workbook (Excel Version 2010) linked to a pivot table. There are several instances that I opened the workbook in excel 2016 , the drop down list is not available. My name was highlighted to my management as the main user and will be placed on improvement plan for a month and if I cannot perform during that period. I will be asked to leave. She mentioned that other users does not have an issue on the excel but she always need to rechecked the formula daily. I felt so bad that I could not sleep for nights.

 

Please help to enlighten me.

What could be the possible reasons forroot cause of formulae run or data errors?

Could you advise if Track changes, or copy and pasting of data from system to notepad and paste in the excel or paste special could resolve the issue?

Or could it be due to Shared version?

 

Thank you

Excel User

Formulas & Functions
Requests
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Mar 24, 2018

    Hello

     

    It is not clear to me what your problem is.

     

    Is it a wrong formula?

    Is it a missing dropdown?

    Is it a pivot table?

    Is it a shared workbook?

    Is it wrong data entry?

    Is it that management thinks you are the main user?

    Is it that you will be ask to leave?

     

    • null null's avatar
      null null
      Copper Contributor
      Mar 24, 2018

      Hi Detlef

       

      So glad that you have replied.

       

       

      My answers to your questions.

       

      Is it a wrong formula? Not sure. As its done by my boss.

      Is it a missing dropdown? Yes from my excel 2016 version. But from her excel 2010 , no issue at all.

      Is it a pivot table? Its around 10 excel sheets in the same file with one pivot table included.

      Is it a shared workbook? Yes , among 5 users

      Is it wrong data entry? Yes , a handful

      Is it that management thinks you are the main user? Currently my colleague is helping to key the first few columns for the past  2 weeks but there was no issue on wrong data previously.

      Is it that you will be ask to leave? Sad to say but my direct team lead and senior came to tell me that its best I leave.

       

      Thanks in advance for your help.

       

      Regards

       

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Mar 24, 2018

        I'm afraid that wasn't very helpful since you more or less answered every question with a "yes".

        It is still unclear what your problem is.

        Maybe you can provide a sample and anonymized workbook with clear indication to the problem.

         

  • Ryan Champagne's avatar
    Ryan Champagne
    Copper Contributor
    Mar 24, 2018

    Can you post your file and tell what it IS doing and what it SHOULD be doing? 

Resources