I love Excel but man… when a file takes forever to open, I start questioning all my life choices. Has anyone figured out a good way to keep files lean when they get huge?

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

I think the question is more why is it huge; like is it rows upon rows of formula, links to external workbooks, are there embedded images etc. I have reduced loads of formula calculations through VBA…. In meantime, turn off automatic calculations, and only calculate manually when you need to.

likesmart

Save as an XLSB to start. The file size will shrink a ton and be faster in general to save and open

likesmart

You can keep both versions active, no need to only stick to one save file if unwanted

Bro trying to run a whole company out of a spreadsheet 🤣

funny

For real though

like

Turn off autocalculation for formulas

likesmart

Thanks for tips

Get rid of unneeded names ranges and external references. That can get bloated depending on where you're getting your data from.

like

If it’s old data you can always hard code formulas, if you know it’s not changing. For me it’s excel plugins that kill it where I need that shortcut most. If it’s too big then maybe try moving to power BI

like

Yea I’m trying to move to power bi now

Use tableau or alteryx

like

think through what you are retaining and if you have any empty cells that think they have data

When files get huge, it’s usually because Excel is being used as both the database and the reporting layer.

At some point, separating the data layer from the output layer makes a massive difference.

Are you storing raw historical data in the same workbook as the dashboards?

Related Posts

Oh boy, they just paged “Mary and Joseph” in LGA C....

likefunny

What type of wellness benefits (outside of insurance) does your school offer?

Anyone have any leads for OCM roles that are remote?

like

$DPZ 370c 3/27

like

What’s does “fill the gap” mean??

like

$BABA got murdered today. Buy, hold, or sell?

like

Anyone with experience with the snoo and any feedback on it? Have a friend that offered to let me borrow hers, so no cost considerations to think about, but have read that it could cause a flat head/other issues and just curious as to what experiences people have actually had with it. Thanks!

like

what is the salary range for a consultant at progression level 1 with accenture in a tier 2 city?

like

I'm an black educator and the only one at the middle school. we had a meeting where we have a new office worker and the principal said we have a new office worker coming in and he is African american

like

What are some of the coolest ways you’ve been shown appreciation? From admin, teachers, staff, students, parents?

like

Hi fishes ,
Is there any referral for the data analyst jobs in Noida, gurgaon.

If yes then pls refer me or share the job description

Thanks in advance

like

Can we get Udemy Business access in Verizon? Or anyother learning portal access?

like
like

What is the salary I should ask for in IBM.. YOE: 6.5, SAP FICO… Current Salary 15 LPA

like

Do you ever catch yourself overthinking a customer interaction for 15 minutes after a call?

like

Do you tell your boss you’re going through a breakup? I’m phoning it in and obviously going to be camera off for awhile.

like

Hi Sharks, Can anyone please share about interview experience/questions asked at PayPal Paypal for java developer 3yr experience?
Is it general core Java based or heavy DSA based? Please help.
Thanks

like

I️ am pursuing a Product Management Internship in Big Tech for next summer. I️ am comfortable reaching out to people to network and know who to reach out to. However, I️ have not found the convos to be all that helpful. Any advice on how to make these convos useful?

like

I can really use some direction. My background, I've worked 2 years in strategy and am currently coming off an exhausting year 2 in investment banking. I didn't particularly enjoy either role and am not interested in moving over to the buy-side or some monotonous FP&A role. Everybody says there's exit-ops aplenty, but I find myself with less options and even more picky than I did as an ambitious T2 undergrad student. Where do I go from here?

like

Is it worth it to go into acting for the pay only? I've received a couple opportunities with decent pay, and while this is not the path I want for my life, it's all I have at the moment.

like

Additional Posts in Excel Genius

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

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

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

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

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

How do I compare two sheets to make sure they are identical?

like

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

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

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

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

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

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

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

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

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

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

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

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