Working with large data set and excel is “calculating threads” when I sort. What can I do to avoid this?

like
Posting as :
works at
You are currently posting as works at

Under formulas, there is calculation option. There is a drop down to turn your calcs to manual. Maybe that will stop the threads

like

Alt m x m

like

Alt f+t to open options window -> Formulas -> Set workbook calculation to “Manual”. Now, for your workbook to calc you’ll have to press F9.

like

Remove any formulae that use columns in that table, eg vlookups. There may be ways to optimise the formulae, eg vlookup approx match = false is very slow, or changing the structure a lot, eg using pivot tables and getpivotvalue.

like

Thank you everyone so it’s on manual calculation now. Does anyone know the difference between manual and automatic calculation? Like how will this affect my work or will it?

If you are sorting and filtering the data to investigate the raw data, you wouldn’t need to calculate unless you’ve changed calculation columns or any aggregating sheets

like

Related Posts

Vice Presidents and up: Is it easy to predict which analysts just won't last the long haul?

like

Is PwC AC bangalore giving permanent work from home and is it being mentioned in the offer letter ? HR verbally saying it's permanent wfh is not really a confirmation.

like

Any single occupancy for Male in preoccupied flat?
Area-Whitefield, Marathalli,HSR Layout, Bellandur, Kadubeesanhalli

like

FYI Amex offer for Allen Edmonds. Spend $300 get $90

like

Off topic

Is there any low interest or interest free loan policy available in thoughtworks?

Current employees, please comment...

like

Hello , how are the appraisals in Cognizant. I was on bench for a month in a year?Cognizant

like

Anyone knows how is Emirates NMD client in Synechron, And do we need to give client interview after joining?

Pretty sure everyone knows I’m stoned rn

likefunnyuplifting

Anyone else feel being a creative director is just not all it was cracked up to be?

like

What have you ladies done with diet, wellness, lifestyle to help balance hormones? I know stress is a huge factor but my derm has been saying that this is a huge part of skin, too. Looking for any input! Thank you

like

The learning and design content I write belongs to the company where I work. Am I able to add and/or share my work in my portfolio? Is it acceptable to create some generic content to demonstrate my skill set?

like

After a decade of experience at big American banks plus consulting, with an American education and passport, how expansive are my options with big and/or small names in the region?

like
like

I’m feeling drained. Unmotivated, uninspired, & bored. My job takes all of my mental energy, but I can’t start looking for anything new yet. Any advice on how to handle a job that makes you miserable?

like

Any Canadians moved to US? Canada is a pretty great country with free health care, wondering if I am missing out...would love to hear your experience.

like

So I’ve been studying for the AWS cloud practitioner certification for a month now and completed all cloud quest levels but still not feeling 100% confident. Has anyone tried the exam question dumps ? There are so many websites but not sure which one is the most reliable one as all of them you would have to purchase such as pass-guaranteed, certwizard, etc.. any recommendations is greatly appreciated

like

How much severance should you expect after getting booted after 1 year. I got 3 months salary

like

Hi guys.. can someone please provide some examples of what is to be written in performance review.
I am new to this organisation and consfused with the performance portal.
Not getting what exactly expected this what and how thing on portal.

likehelpful
like

Additional Posts in Excel Genius

What would you consider "Advanced" or "Expert" level Excel usage?

like

How useful are Macros and VBAs for tax prep?

like

Hey everyone! I am working on a report with the intention of updating the products that a specific customer uses. Currently, the data is arranged with the unique ID in Column A, and associated products in Column B. However, each product has its own row so company 1234 might have 5 rows and company 5678 might have 20. What I need to do is collect the product data for each unique company and put it into a single row, separated by a comma(s). I am at a crossroads, any suggestions?

like

How can I resize the horizontal scroll bar to only fit to my data? It goes all the way to column XFD and my data only goes to GK. Someone once had formatting that far out and now it won’t resize

likeupliftinghelpful

Anyone have a good source to learn sql

like

How do you fix microsoft excel cannot paste data error?

like

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

likehelpful

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Would anyone be willing to teach me vlookup?

like

Help unhiding columns A-D in excel. I've tried putting A1 in the select cell selecting unhide columns and also youtube to no luck. Please help.

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

I have a large dataset in PowerBI (7m rows) and I’m trying to condense it to pivot in Excel by aggregating the data. Does anyone have experience doing this? How do you pivot and export in Power BI?

like

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

like

What's a simple way to explain data organization to people who don't use formulas very often? People on my team love creating many tabs instead of adding columns for recording the same type of data...

like

My sheet has multiple cells with Notes. Whenever I reorder rows or add new columns, the notes go completely out of whack (get displaced or squeezed). Any quick fixes? Also why does this happen?

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal