I have a large binary file (20mb) . When trying to reference another workbook in formula, excel won’t recognize the other workbook. Any fixes? I’ve been trying to reduce size

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

Have you tried a middle out compression

funnylike

If turning the file into a binary format doesn’t work the only thing I can think of: Is the other open workbook part of another Excel application instance? I.e. do you see two Excel icons on your task bar at the bottom of the screen? Only asking because this happens infrequently, but different Excel instances can’t talk to each other.

like

Avoid referencing other workbooks as a rule of thumb

like

Alt3ryX

funny

turn the other workbook into a binary file too

Cmon bro

Related Posts

Firm Veteran Initiatives are primarily aimed at prior officers and it infuriates me. There are very capable prior enlisted out there that are being overlooked.

like

I recently discovered that my nanny told my 2 month old that God will watch over her and I'm concerned. I want to be the one that introduces her to religion, and I'm worried that this indoctrination is just going to confuse her. Should I fire my nanny?

funnylike

Would you recommend incorporating a business in Canada using Ownr ?

I should say a start up, so would have employee stock options, vesting periods etc.

like

I feel like I can't do anything efficiently. My managers give me really simple tasks and it takes me 16+ hours to complete them. No one has made a comment but I feel SO SLOW. Any advice?

like

Can anybody suggest any books or resources to get smart on medical device marketing and/or medical device manufacturing?

like

Is RE equity building overrated? I have been doing deep analysis only to find out that bank mortgage interest makes a deep cut into whatever equity I think I am building by renting out properties. This is despite having the1% rent wrt property values. Is appreciation what makes this worth for investors? How do I all calculate break even ?

like

Thoughts on McKinsey’s valuation guide for a junior investment banker who took Damodaran’s undergrad equity valuation course (but could use a refresher!)? Is the incremental knowledge useful enough to be worth the time and investment?

like

Book recommendations. Your favorite -
1. Autobiography/Biography
2. Self Help
3. Financial Literacy
4. Non-Fiction (not from 1,2 or 3)
5. Fiction
Go!

like

What’s the most egregious case of “pointless display of wealth” at your office?

like

I know this is a vague question but if anyone could give insight on the salary range for a personal assistant for a CEO of a staffing agency of about 50 people that is growing in NYC?

like

How frequent are night shifts in PWC?..Is there any allowance for it?

like

My company was acquired last year & new terrritoy assignments were made Jan 1st. The old AEs had until the end of Jan to close out deals they were working to receive 100% commissions & quota relief. The new AE taking over received 50% comm if the deals closed in Jan. After Feb 1st, the new AE taking on the account received 100% comm and the old AE received nothing. The two deals I had worked for months and in procurement Feb 1 close last week at 445k & $399k. $60+k comm to new AE - $0 to me. 😩

like

Anyone from Boston Consulting Group Boston Consulting Group (BCG) working in non-consulting - Technology/Engineering/Global Services?

How's the work life balance? Glassdoor reviews are full of "long working hours" and hence wanted to know if it's the same with non-consulting folks as well?

How far is it true across the organisation?

Please help me shed some light to decide.

Thanks.

like

I have an interview with JP Morgan this week for a Channel Marketing Manager - VP role in the Asset Management area. The role will be based in NYC. Just curious what is the normal range for the base salary and total comp.

like

How many Partners here made it at their first company?

Did you have to leave to move up? Is it easier to make Partner at your 2nd or 3rd firm than your 1st?

like

PhDs of Fishbowl, what's the worst thesis premise you've ever encountered?

like

What's the base salary for a product manager or product owner? Just comparing myself 50k with RPU possible to 10% of base. Based in North Europe.

like

Currently working in a Management Consulting role in Big 4 (not front office). Got an offer from Product Based company that is more of value consulting and business development role. and Its a new team catering to Partner ecosystem of the company. I am doing good in my current role.

Any insights or suggestions would be greatly appreciated

like

Hello fam,
Suggestion for pre-hair straightening heat resistant serums/sprays please?

like

Just got my appraisal letter. Indian 🐠 is 11lakh for a SC in Big4 strategy consulting low? They’ve said this is the norm and it really feel low.

like

Additional Posts in Excel Genius

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo
like

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Does anyone know how I can conditionally format a table with a sliding scale? I have a value that is supposed to fit in a range. I need the first possible range the number can fit in to be formatted. Thanks

likehelpful

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

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

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.

If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.

Thanks in advance

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

What are the most typical models you all build

likehelpful

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

Ok, using excel is not a primary function for my role (this will be very obvious shortly...) So please be kind! On my sheet, in the first and third columns, I have lists of reference numbers. In the second column I have a client name. I already identified the duplicates in the first and third columns using conditional formatting.What I need to find now is column 2 value, whenever value in column 3 is identified as duplicate. Problem is, I have over 120k rows of data so I can't filter! 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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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