Question description:
This user has given permission to use the problem statement for this
blog.
I have an excel sheet that everyone in the company uses for Purchase Orders. It has always worked and for everyone else it is still working except on my computer EVEN IF I USE THE SAME ONE THEY HAVE. what could be going wrong?
We have a column for price, then discount, then quantity. it used to always add the total after the quantity and is no longer doing so. Please help!!
Solved by M. J. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
20/09/2018 - 10:29
Hi, welcome to Got it Pro-Excel!
Excelchat Expert
20/09/2018 - 10:30
Let me ask you a couple of quick questions to make sure I fully understand your problem.
Excelchat Expert
20/09/2018 - 10:31
First, will you be able to send me the file so I can test it from my end?
User
20/09/2018 - 10:32
Yes
User
20/09/2018 - 10:32
https://docs.google.com/spreadsheets/d/1Mmsx9UJCVU-YbY1cnkZ5uqoHoweuNrAWDySnw7pb4nA/edit#gid=894607090
Excelchat Expert
20/09/2018 - 10:32
Is this the actual file that all of you are using?
User
20/09/2018 - 10:33
It is a copy as the original template can not be typed in. everyone clicks "make a copy" of the origial
User
20/09/2018 - 10:33
original
Excelchat Expert
20/09/2018 - 10:33
Ok, noted. Give me a moment.
User
20/09/2018 - 10:33
It is working for everyone except me. Sometimes it will work for me on the first few lines and then towards the bottom stops adding
User
20/09/2018 - 10:34
Thank you!
Excelchat Expert
20/09/2018 - 10:34
I don't have access to the file. Kindly allow everyone to access it, thank you.
User
20/09/2018 - 10:35
https://docs.google.com/spreadsheets/d/1Mmsx9UJCVU-YbY1cnkZ5uqoHoweuNrAWDySnw7pb4nA/edit?usp=sharing
User
20/09/2018 - 10:35
Ok that should work
Excelchat Expert
20/09/2018 - 10:35
Ok, I made a copy for myself so I can edit it.
Excelchat Expert
20/09/2018 - 10:35
Give me a moment to analyze your file.
Excelchat Expert
20/09/2018 - 10:35
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
User
20/09/2018 - 10:36
Okay
Excelchat Expert
20/09/2018 - 10:36
Ok, this worksheet looks simple. Can you tell me more about your problem, step by step.
User
20/09/2018 - 10:38
When I put in unit price I then need to add the quantity. After adding quantity it should put the total on the right side, as well as add to the total at the bottom of the page. It is no longer doing that for me. Also- sometimes it will do it on the first few lines but then will stop halfway down and will no longer add the total
Excelchat Expert
20/09/2018 - 10:38
Ok, let me try that on my end.
User
20/09/2018 - 10:39
Most times when it does this, the font also turns Red out of nowhere. Or I will type in quantity, it will not add to the total, I will then delete quantity and then it will add whatever total it should have been but quantity will show 0
Excelchat Expert
20/09/2018 - 10:39
It's working fine with me. I tried 3 lines.
User
20/09/2018 - 10:40
That's what everyone at work is saying too. I have been using this same file for about a year with no issues. It started yesterday and I have not done anything differently.
Excelchat Expert
20/09/2018 - 10:41
Which browser are you using?
User
20/09/2018 - 10:41
Microsoft Edge
Excelchat Expert
20/09/2018 - 10:41
Do you have any other browsers aside from Microsoft Edge?
User
20/09/2018 - 10:41
No, But I can download a different one if that will make a difference
Excelchat Expert
20/09/2018 - 10:42
Yes, I'm thinking it's your cookies and temporary internet files. Let's see if that'll work. Try downloading Google Chrome.
User
20/09/2018 - 10:42
Ok, I will do that. Thank you.
Excelchat Expert
20/09/2018 - 10:42
Let me know once your downloaded Google Chrome and tested your sheet if the problem persists.
Excelchat Expert
20/09/2018 - 10:43
I'll wait here. Make sure to extend our session when our timer hits below 3-minute mark.
Excelchat Expert
20/09/2018 - 10:47
Hi, kindly extend our session from your end so we can continue to support your problem.
User
20/09/2018 - 10:47
Ok, it appears to be working much better now.
Excelchat Expert
20/09/2018 - 10:47
Thank you. Let me know if you're done testing it via Google Chrome.
User
20/09/2018 - 10:47
Thank you for your help!!
Excelchat Expert
20/09/2018 - 10:47
Oh ok, is it working as expecteD?
User
20/09/2018 - 10:48
Yes
Excelchat Expert
20/09/2018 - 10:48
**expected?
Excelchat Expert
20/09/2018 - 10:48
That's great.
Excelchat Expert
20/09/2018 - 10:48
Would there be anything else I can assist you with regards to the original question and the solution provided?
User
20/09/2018 - 10:48
No, that was all. thanks again
Excelchat Expert
20/09/2018 - 10:48
If that's all, I'd like to wish you have a very nice day ahead of you and we'd love to hear from you again. Feel free to leave a rating and comment at the end of this session. Thank you for using Got it Pro-Excel!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.