Hi Everyone, I work extensively with large Excel files and often face delays due to network performance. I’m currently using Microsoft® Excel® for Microsoft 365 MSO 64-bit. Is there a better version of Excel or an alternative you’d recommend reducing interruptions? One of my files, saved as a binary, is 11,204 KB and runs slowly. Thank you for your help!

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

Depending on what you’re doing maybe you can leverage SQL

like

Could you ask your corporate IT department for help with this?

like

Check your add-ons, maybe disable a few

like

Maybe it isn’t Excel but what you’re doing in Excel. Can you describe what kind of tasks you are performing.

I’d recommend using MS Access or some other kind of SQL DB.

If you are experiencing latency issues, you are using the wrong tool. Even if you say “I’m just doing pivot tables!” If you’re working with data pushing the threshold of excel’s limits… go do your task in SQL, Python, any other tool that doesn’t have these limitations.

Excel has these limitations because at a certain point, what are you doing

I’ll add, every tool has limitations. This is one of excels. Too many rows/columns? Use another tool.

I tell this to people who run into your issue in Python, and there’s an answer there too, use Pyspark. It’s not a you thing. It’s a tool thing.

11mb is not that large of a file. There may be an issue with add-ins or something being done in the file.

As an alternative, I often use Python and pandas dataframes for data extraction and transformation from Excel files. It works well for single person or small team processes. However, larger team deployments can be challenging.

If you utilize a lot of X/V/H Lookup functions/formulas in the files consider the use of SUMIF or SUMIFS. The lag or delay Lookup formulas cause when used excessively could present as being network issues.

Related Posts

How many emails do you receive in a day? Is it normal to receive 15+ emails before 7:30 every morning?

likefunny

Do we have to sign a bond if PWC buys out an employee from the previous company?

like

Does anyone know the standard package for secondment coming to Sydney?

Looking to pivot into managerial. Can someone take a look at my resume? Tips would be appreciated as well!

likehelpful

Hi Fishes,

Need some suggestions. I gave interview on Tuesday, will it be right to ask feedback tomorrow or should I wait till the end of week and then ask for feedback on Monday Morning. Today, I didn't got any response from them.

like

How long does it take for Morgan Stanley to get back after a Superday? It was with the FRM division btw. Morgan Stanley

like
like

15 YOE, recently started my first tech PR job at a large, stable company & have been asked to get ~20 SMEs in front of media. Subject matter is not sexy. I lead PR for all of U.S. & have no other PR colleagues. My agency’s budget is 100k/year & they’re spread too thin to hit their KPIs. I feel set up to fail & feel we should be focusing on a handful of SMEs and only our sexiest topics. Any advice on mitigating unrealistic expectations for coverage? Anyone handled similar problems in the past?

like

Hi fishes, do qualifications like B.E, BCA or BSC decide the CTC?

like

Hi everyone. I am trying to change my current company. I am currently working with Stonex and have experience in financial domain for 11 years. My profile is in Surveillance Compliancen, Kyc Aml, QA Six Sigma, Trade Surveillance and ecommunication Surveillance. It would be great if i would have got one referral.

Thanks.

like

Thoughts on homage watches?

like

Can we get a comp discussion going here 💰💰

Does the company provide fringe benefits?

like

Looking for practical tips and strategies for becoming comfortable as in-house counsel (I.e., anything more specific than the generalized advice to “be a business partner” and “learn the business.”). What’s the best way to stay organized? Should I proactively reach out to business teams to see if they need anything? How long did it take you to become comfortable in your role?

like

Question for my fellow veterinarians: do you wish you went into Human Medicine Instead and why not?

like

What is the annual appraisal range for financial modeling associate at Ahmedabad, India?

like

S&P Global Is it wise to join S&P Global during recession time? Can we consider this company as recession proof. Any history on layoffs in the past ..

S&P Global

Has anyone bought anything from Vestiaire Collective?

like

Hello Fishes,

A component in the Remuneration structure named "Organisation's contribution towards wellbeing". Could you please help me understand what does it include? Is it subject to reimbursement?

Requesting the fishes to give some clarity on the same.

like

Did any PM or PMM get into b-schools like CBS or NYU to make the transition? Would love to chat!

like

Additional Posts in Excel Genius

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)

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

like

What are your top Excel ninja tricks? Ones that few people know...

like

Would anyone be willing to teach me vlookup?

like

How do you fix microsoft excel cannot paste data error?

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

like

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

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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

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

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

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 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

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

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

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