Excel frustration - sorting formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2597265%22%20slang%3D%22en-US%22%3EExcel%20frustration%20-%20sorting%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597265%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20a%20frustrating%20time%20with%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20starters%20I%20am%20not%20a%20beginner%20user.%20I%20use%20excel%20on%20a%20daily%20basis%20at%20work%20and%20have%20used%20excel%20for%20decades%20for%20my%20personal%20finances.%20This%20has%20never%20happened%20to%20me%20before.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20new%20laptop%20(Microsoft)%20with%20excel%202013%2C%20and%20was%20doing%20some%20work%20in%20excel%20when%20I%20created%20a%20small%20chart%20that%20includes%20names%2C%20totals%20and%20percent%20of%20total.%20I%20wanted%20to%20sort%20those%20excels%20by%20percentage%20so%20the%20highest%20percent%20item%20was%20at%20the%20top.%20The%20totals%20and%20the%20percentages%20are%20all%20formulas%20gathering%20data%20from%20elsewhere%20on%20the%20page.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20as%20I%20normally%20do%20and%20highlighted%20everything%2C%20did%20a%20custom%20sort%20indicating%20I%20wanted%20to%20sort%20based%20on%20values%20from%20highest%20to%20lowest.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20it%20sorted...all%20my%20totals%20and%20percentages%20changed.%20All%20of%20them.%20The%20formulas%20went%20wonky.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20some%20google%20searches%20to%20try%20to%20figure%20out%20why%20this%20happened%20and%20found%20advice%20to%20press%20'A4'%20to%20make%20the%20values%20absolute.%20A4%20does%20nothing%20on%20my%20laptop%20but%20turn%20the%20microphone%20on%20and%20off..%20I%20tried%20inserting%20the%20'%24'%20symbol%20strategically%2C%20and%20this%20didn't%20work%20either.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20going%20on%20here%3F%20any%20tips%20or%20suggestions%3F%20I'm%20getting%20very%20frustrated%20with%20this%20program.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2597265%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597269%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20frustration%20-%20sorting%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597269%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1117676%22%20target%3D%22_blank%22%3E%40Burdee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20attach%20a%20sample%20workbook%2C%20with%20sensitive%20information%20removed%20or%20replaced%20by%20dummy%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Good day,

 

I am having a frustrating time with excel.

 

For starters I am not a beginner user. I use excel on a daily basis at work and have used excel for decades for my personal finances. This has never happened to me before.

 

I have a new laptop (Microsoft) with excel 2013, and was doing some work in excel when I created a small chart that includes names, totals and percent of total. I wanted to sort those excels by percentage so the highest percent item was at the top. The totals and the percentages are all formulas gathering data from elsewhere on the page. 

 

I did as I normally do and highlighted everything, did a custom sort indicating I wanted to sort based on values from highest to lowest. 

 

When it sorted...all my totals and percentages changed. All of them. The formulas went wonky.

 

I did some google searches to try to figure out why this happened and found advice to press 'A4' to make the values absolute. A4 does nothing on my laptop but turn the microphone on and off.. I tried inserting the '$' symbol strategically, and this didn't work either.

 

What is going on here? any tips or suggestions? I'm getting very frustrated with this program.  

 

Thank you

1 Reply

@Burdee 

Could you attach a sample workbook, with sensitive information removed or replaced by dummy data?