Excel is one of Microsoft’s premier productivity apps. CEO Satya Nadella said in June 2016 – “there's one product that stands above the rest as the best consumer product that the company has ever mad...
Updated Jun 13, 2018
Version 6.0
Blog Post
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 , 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