Anyone ever had Excel stop performing functions due to a full memory? I've tried closing some files out, it's still not letting me edit :') oh happy day.

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

Either you're running excel on a toaster, or you're using excel for something it shouldn't

like

Make sure you have the 64 bit version and not 32 bit. It enables Excel to use more memory and should fix your issue. I haven't had this type of issue for many years thanks to using 64 bit.

like

Both Excel and your machine have limits, if you max those out you’ll get it to crash every time. That’s why it’s so important to write common sense code/formulas and minimize data and cell usage.

like

What is the size of your file? You may want to look at using power query.

Yes but not in a very long time. Agree excel is probably not the right tool for whatever you’re building.

Related Posts

like

That Friday feeling

Post Photo
like

Anyone in canada get their bonus info yet? Happy with the outcome?

like

Any advice on networking to find a new role? I've worked in the same place for so long and I'm not sure how to get started.

like

Started as a BDR and got moved into partnerships within the same org. Comp was initially 75k CAD with OTE 120K CAD. New comp for new partner channel I am carving out, I am offered same base but guaranteed 75% quota attainment payout. Is this a fair comp? Would love any constructive thoughts/points on this. Company is in eComm vertical

like

I work in field sales as an IC. My aspirational career path is to end up in people leadership. Recently, an Inside management position opened up that’s been brought to my attention by the hiring director. Question is, is going back Inside the right move to get into started in leadership? Or should I continue down the field path and wait until those field management slots open up?

like

DM for referral

Post Photo
helpful

Moving to the city next week and found out that I need to set up internet (obviously 😅). Any tips on how to go about it? How long it’ll take? Never done this before and I work from home/need internet soon when I move in

like

Sharks, is there any project release policy for Cognizant ? Kindly let me know from where i can get the policy ? I want to switch the project . Reason - No scope of learn new technology in the new project . Tata Consultancy Accenture India Wipro wipro IBM

like

Hi, I'm going on a family vacation to Dominican Republic in January. Looking for some suggestions on best things to do, see and experience.

How do you stay productive when you're working remotely?

like

Creative Director: “Craft and storytelling will always be fundamental in this industry.”

Same Creative Director: “So they flip the Yoplait Yogurt cup on Tiktok as a...challenge? Sure, why not if the kids are doing it. But what’s the hashtag?”

likefunnyuplifting

Any advice on how to find new creative interns in NYC? We aren’t a big agency but we have some great opportunities!

likehelpful

I would like to learn more about development and real estate. Can anyone recommend any books or courses that you think are informative. Eventually I would like to own a few apartment buildings, but I know there is a lot I need to learn 1st. Any advice appreciated. 

like

I could use some advice on how I should handle this situation. I found out the other day another editor who started four months ago is making 8% more than I do. For context, I have been here for a little over a year. How do I approach my boss to inquire about a raise? Should I bring up that I know about my teammate's salary?

likehelpful

Why does a H1b visa stamping get rejected? Are there things I can do to avoid rejection?

like

"she doesn't have good boobs" †
👀

likefunny

Pwc AC
I am an Software Engineer Analyst in my current organization yoe 2.8 years, and is offered an Associate L2 position in big4.
Is it correct position to go with according to my yoe or I should apply for senior associate?? Please suggest.

What would be an appropriate gift if I want to show appreciation to my juniors before leaving the firm to go in house? What about for partner/counsel?

like

Additional Posts in Excel Genius

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

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

Any book recommendations on excel modeling for real world business applications?

like

Still don't have xlookup. #fomo

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

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