Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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

Save as .xlsb

like

Clear names ranges

like

What happens to formulas referring to named ranges? Do they convert automatically?

Press Ctrl + end and delete empty cells

like

This👆.
I think MS even has an add on to do this

Turn off automatic calculations

like

Cleaned up the Name Manager, knocked off 6MBs. Not many bad last cell references, only saved 1.5 MBs. The thing is just massive. Workable now that Name Manager is fixed. No broken keyboards (yet).

Related Posts

Hi Sharks can you please tell me which can be a better option for me in case of job security and work life balance
Yoe : 7.9
Tech stack: endpoint manager SCCM
IGT (dufry client) : 22lpa includes 5% variable (complete WFH)
Mphasis (UCB Pharma client): 21 lpa including 5%variable - Hybrid working
Techm: 19 lpa + 1.25 joining bonus
TCS : 18.45 lpa

like

I joined pwc almost 2months before not yet billable, working in a temporary project as non billable resource, is it safe ?

like
like

Hi

I have joined IBM and resigned within 50 days.
Reason: project I was allocated not good and I initially rejected project but they forcefully moved to the project.I have asked multiple times to replace the project after that I have resigned.
Now manager is threatening me that I will be placed under no hire to IBM.
Is it ethical?

like

Hi all,

I'm currently working in enhancement projects!

I had worked previously before in support project and a bit of development project also.

Can anyone help me how can I go about learning all .net related technologies and what should I focus on?

A campaign my partner and I thought of went into testing, but died in the process. Same idea, concept, name and execution used on another client/ campaign just a month after, that we weren’t on. Few people from the old team were on this new campaign. We’re disappointed about it and wondering if this is a common thing that happens?

like

Currently on bench, any project
opportunities please let me know
Role - senior consultant
Skills: FSD with .net, angular 8+, sql,postgresql

What is McK London WFH policy now? Is it still work from home any number of days of the week you want and project allow or have to go in a couple of times a week?

like

I'm currently an SEO Analyst/Web Developer/Digital Marketer. Looking to be more client facing in the future. You think I have a chance in an Account Management role?

Anyone know what the current atmosphere is like in McCann New York after they lost one of their biggest clients, U.S. Army? Does losing such a client deteriorate an agency’s culture/career prospects?

like
like

Is it safe to join Wipro during this hiring freeze period. I am worried if I will get allocated to a project soon post joining.12 YOE , Java background and Architect role. Joining is in mid August.

How is it like working with EY HUL client as a senior consultant?

like

Anyone has knowledge of EY structured finance group? WLB? Client base? Team culture? Exit opportunities?

Please share your insights. :)

What's the best way to get your project changed in IBM?
Working in energy utilities account for last 10 months as a BA, but the work is not good at all.
Should I try to check with my people manager or look outside IBM ?

like

Hi folks,
Need ur suggestion!
I am havng 2.7 yoe and working in project in ibm past 2 months. I am facing difficulties in settling in this project. As it’s early stage of my career I need to learn and then implement but because of that I am daily facing pressure and I am daily worried abt my work . How to overcome this pressure? Sometimes I feel to take release but on other hand I think I need to face and learn !
Plz help

like

Hi Fishes,

I have worked as a contingent employee in JPMC in one of their project.
After how many days can I apply for a permanent role with them ?JPMorgan Chase

Hi fishes,

My friend in Dxc getting calls for libertymutual , does this project is good pick

Yoe - 3.5
Tech stack - Java dev

likefunny

I am an AE moving to a PM role at my agency.

Since I will have the PM title, what is the roadmap for moving to FAANG (or similar) or SaaS digital end to end dev/implementation companies as a Technical PM/Senior PM/Program Manager?

I have 5 YOE in Account Management, 2+ of which are in heavy digital working with Dev, Digital PMs, and client tech/implementation teams.

I also have had some direct experience in PM and will be building those specific skills in my new role.

like

Hello Fishes,

I am a 2022 MBA graduate working at Deloitte as a consultant. I am a part of their internal strategy team (non client facing role). I have a prior workex as a software developer and I am looking to make a move to Product Management.

I want to understand few things
1. How difficult is it to move to a PM role with no workex?
2. I am getting paid decently here, does PM jobs also pay highly (I am expecting a CTC of ~25-27LPA)
3. How to prepare for the interviews?

More Posts

Howdy Sales Fishes - I’ve got an interview coming up and the recruiter prepared me by sharing that the interviewer may be low energy intentionally. Does any have a best practice for tactfully responding to this behavior or should I just persevere?

like

How do hit 10,000 steps these days? I workout at 6am, start work at 8 am and finish at about 8 pm and sleep at 10. Any tips how and when to squeeze in a walk?

like

So I'm a bit scared want to make the pivotal to tech after my MBA but noticing a huge difference in Consulting salary (165k) and tech (133k). Does RSU help cover the gap?

like

I made a couple errors at a new job. An important document to be distributed had wrong information on it, which was proofread by 2 other people. Then a couple of typos in emails, the person micromanaging me told me to send out but I didn’t fix the errors. Failed to meet a deadline but completed 95%. I was written up over all this last week, fired this week. There’s a lot more to this but I think it’s because the DM doesn’t like me.

like

Want to get thoughts culturally on A&M vs EY in general - as I’m looking at different practices (OTS, PE) but also anyone who has done work in different practices

likehelpful

trying to make a move into FDD...any insight into how i should prepare, know, gain skills etc. for interview and networking!

like

Hello, Can someone refer me at Amazon. I have 16 yrs exp working in Accounts & French operations. Looking for day shift opening only. Thanks in advance!

like

Which one to join GSK(X+3 bonus + 1 JB) as Data Engineer or Fujitsu consulting (x+3) fixed as System Architect??

Not able to clear Independence Training for new joiners can anyone help how I can clear this?

like

Hi folks! If I quit this week, will I still get my bonus? (My LWD will be around September 26-27)

like

Hi Fishes! I am searching for an opportunity in Financial Planning and Analysis role (Finance) with 7.7 years of experience. Any leads ? Appreciations in advance !!

like

Best site, book, podcast to learn about men’s fashion and the formalwear industry. Want to join a menswear company and want to get up to speed as much as I can. Thanks all!!

like

What should be my expected salary for SDEIII(SDE3) in Walmart
YOE: 3.5
Current Organization: SAP
Current compensation: 13.6 LPA
No other offers in hand

like

What is typical salary range for Sr. Consultant at Deloitte India Consulting. YoE - 3. MBA Tier 1 college.

I just want to move to ACN strategy 😪. Done BD work, strategy type projects etc. Why is it easier for me to leave to join S&/S&O/etc rather than transfer within my own firm! Smh talk about turnover.

like

What do you include in your competitive audits? (Not creative)

During the warm weather months I try to set up impromptu events (Storefronts, etc.) where I can be in front of people at little/no cost. How do you guys proceed to take advantage of the summertime?

like

Hi all, has anyone temporarily transferred to the Canadian office of their firm and done the Canadian PR application while they were there on work visa?

like

Recommendations for good movies and shows on Netflix, Hulu and Prime?

like

Additional Posts in Excel Genius

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

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

How long did it take you to become good at excel? Like fast?

like

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

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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)

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

I have some data extracted from SAP and though the size is not relatively high lets say about 45000 line items. My excel keeps crashing anything i do with it 🙄! Any clue why it is happening ?

like

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

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

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

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

like

Still don't have xlookup. #fomo

like

Would anyone be willing to teach me vlookup?

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

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