{ "media_type": "text", "post_content": "Is Excel extremely slow at updating/calculating formulas for anyone else recently?", "post_id": "601c860fd07f4e0021fc83af", "reply_count": 5, "vote_count": 5, "bowl_id": "5a56f68d15f6ef0013aad256", "bowl_name": "Excel Genius", "feed_type": "bowl" }

Is Excel extremely slow at updating/calculating formulas for anyone else recently?

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

Always depends on amount of data and formulas present already

like

Yes. Since 1995.

like

Formatting in blank cells is a frustrating culprit. The ol' "white fill to hide gridlines" one is my favorite. Saw an 8mb file go down to kb once.

like

Do you have data tables

I am facing this challenge recently with just 2-4 files open on a 8GB RAM machine and it freezing on me.

Possible reasons:
- Office 365 subscriptions managed centrally by Org policy resulting in no updates or late updates
- Large data sets with multiple file linked to each other
- Files stored on network and being edited remotely

Additional Posts in Excel Genius

Considering buying my first home (condo in florida) trying to learn about mortgages and financing.
Any advice or resource recommendations?

like

Does anyone know of any mortgage loans that doesn’t require PMI even if you put down less than 20%?

like

I feel like my ex could hit me with a car and the girls who run our friend group would still find a way to support her

funnylikeuplifting

White women believe they are “minorities”!

Post Photo
funnylike

Any RPA consultants in this bowl? Or know anyone in the RPA team?

like

Gay men: who do you think is the most handsome model / actor around on Instagram? do you think you have a ‘type’?

likefunny

IBM has an opportunity for Microsoft Xamarin Developer, can anyone refer me in IBM for the same YOE: 3.3 Yrs Notice period: Immediate
Preferred location: Mumbai Please do ping here if anyone can help me out IBM

like

So who’s leaving?

like

Anyone looking for a 1 bed 1 bath in West La till next October? 2k rent right off sunset Blvd by the Getty

likefunny

I’ve been taking care of my sister who’s going through chemo for the last two months and I’m so exhausted…. And I feel like I have it easy. IDK how caregivers do this day in and day out.

like

Dear Client, I really appreciate you pay for my food when I'm on the road. Happy holiday! Truly Yours, consultant.

like

Hi Fishes,

One of the organisation has set up a personality test as part of there recruitment process. This will be my 5th round of discussion with then (2 technical, 1 functional and 1 managerial). Anyone has any idea how I can prepare for this round and what kind of questions to expect.

My YOE: 10.6
Technology Stack: SharePoint, Power platform

Thanks for the help in advance.

What is the biggest thing you think students are missing when they move from middle school to high school?

like

Has anyone ever successful negotiated there salary with the federal government. I have tried twice and both times was cited a HR policy saying my specific circumstance did not allow negotiation. Just wondering if it’s even possible

like

I personally feel that prenups are proposed by people who value material possessions more that deep personal connections. Also feel they are pessimists but I could be wrong. What do you think?

like

I've been out for 7 years and have hooked up with a lot of guys. But never been in a relationship and never really cared to be in one. But everyone I know (gay or straight) is getting into serious relationships and/or engaged.

What's wrong with me? Why is it that I don't even try to date (banging is great I guess)?

likefunny

Hi ladies, is it normal to have 3-5 quarter size menstrual clots a day? Been ongoing for two days and I rarely have menstrual clots before.

like

Is it inappropriate/advised against sharing my food Instagram with teammates? I also have a personal page that is public and also used as a blog and the two can be connected to each other. Someone asked about it in a slack channel that is all female engineers but Ofc I can’t control who it gets shared with outside of that

funny

Additional Posts (overall)

Is it possible to see who has opened an excel workbook? I know you can see edit history, so I’m looking to see if there is something similar for file open. Thx 🐠

like

How can I goal seek tariff (price per unit) to meet a certain Equity IRR based on a target Hurdle Rate using VBA? Can anybody please share a code or explain it to me like I'm a 12 year old. 🙏🙏

like

Hello Excel Geniuses- I need help. I have never learned macros but I’m about to but before I invest the few hours or however long it might take, I wanted to find out if it is possible to do what...

likehelpfulfunny

Trying to figure out how to understand the variability of price data along a downward trend. Any ideas? If the data wasn’t trending, I’d just evaluate the distribution of data, maybe normalize it.

I recently switched my jobs and I am doing a lot of analysis in excel using big data given to me. Are there any courses or any videos I can watch to enhance my analytical skills using excel?

like

Question for anyone who does real estate financial analysis. How experienced or advanced were you with excel before you started you first real estate analyst job ? Did you learn a lot of it on the job or were you expected to know a lot about excel modeling beforehand?

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Happy Friday Eve

Post Photo
likefunny

When I try to reference a cell in my formula, it won’t let me even click on it and I get the error “There’s a problem with this formula. Not trying to type a formula? When the first character is an equal or minus sign, Excel thinks it’s a formula”

like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

How to apply conditional formatting across tabs in excel sheet? In a drop down data validation I have A (Green) B (Blue) and C (Red). I selected the cells I want to apply, hit format painter and then selected the cells where I want to apply on next tab but not everything carries. Wondering if any tips on what I’m doing wrong

like

I have about 10 variables each with a certain score (10,14,15, 20,20,20,7,9,2,1). I need the max value is there is a single winner (MAX function work here.) If there is a tie for the highest score, I need an output that says “Multiple.” How would I go about this?

Thanks in advance!

like

I have a large dataset and when I filter, I keep getting up pop ups that say “fixed objects will move”. How do I get this to stop?

like

I’m trying to work smart & not hard- started recently and what’s some of excel features you recommend I need to get in habit of (short cuts etc...) help.

likefunny

Hey everyone, I'm looking to get some help tracking product sales for my business. I have an excel sheet, but it still needs some work. Can anyone help?

Thanks

like

How can I index match a relative value?

I want to look up the per unit cost of 280M units, but don’t have an exact match. The numbers in the picture below are actual units/infra I’m searching against

My formula is currently =index(D26:D48,match(B56,B26:B48,1)

Post Photo
like

Also posted in data analytics bowl, but quick question. I am looking to use Tables 1 and Tables 2 in this screenshot to yield the “ideal outcome” table in Power BI (using query editor). The tables I have setup look similar to Table 1 and Table 2 (it’s a mapping activity of controls to various categories). Is anyone familiar with the proper steps / video that will help me arrive at the ideal outcome?

Post Photo
like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

I have a master data list on sheet 1. Need to split the data by location (4 locations) on other sheets but only want to update sheet 1 as I get more data. How can I make it so?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
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

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

New to Fishbowl?

image with Fishbowl logo and arms reaching out for a handshake

Already have an account? Log in

By continuing you agree to Terms of Use and Privacy Policy.
Messaging rates may apply

For account settings, visit Fishbowl on Desktop Browser or

General

Legal