Company I’m consulting for has excel files linked to other excel files on their sharedrive. Typically each has links to 20+ other excel files, and one I’m working on now has 102 external excel file links. Opening one has a spiderweb of connections as other files have links too. This is the first time I’m seeing something like this and seems very inefficient and lead to errors, eg file name change or location change. Am I correct in assuming this isn’t a best practice and requires change?

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

Definitely a risk, but very common. Are you looking for improvement recommendations or just concurrence?
-edit it doesn't inherently require rework if there are sufficient controls (process flow maps, checks, sign offs, etc.)

like

Ideally I would have everything in a data warehouse that would reference, so only one link. But this is a small company entrenched in doing it this way with minimal controls, nightmare to even fix a bit of it

smart

Ummm sounds like they need a RDBMS to me. Need help with the proposal?

likefunny

102 external links to other files?.... Jesus Lord

likefunny

Not including the links from the files they link to…

like

Rename/move a file to show them what can go wrong and how bad it’ll be.

/s

like

Agree with EY1. That’s definitely not good. Files should be self-contained without links

like

You can bring it all in a powerquery model to speed things up

Kind of, but it’s pretty flexible with what you can do. Ideally data should be a tabular format

likesmart

Alteryx? But doesn’t really help with the untangling, just the future management - but maybe some opportunity

Related Posts

**Associates** looking to get into the deals, KPMG practice, reach out for referral

like

If any one looking for any referral from EY GDS. please dm me.

like
like

Former Big 4 Ms / SMs looking to transition to an industry HR role - would you recommend an MBA or a Masters in HR to help with this? If so - what are some good programs for this?

like

Any possible referral for BCG generalist Associate role? Looking for UK, India, or Singapore. Currently based in Europe, looking to move to an English speaking country to be considered for generalist roles pre MBA. Thanks a lot!

Hello, does anyone work as an auto underwriter for insurance? I recently got accepted for an internal job position and was offered $50k. I’m currently a claim processor making $20/hour so the offer is more than what i’m making but is low in comparison to the average salary for an auto underwriter in AZ (which is around $58k). I believe because the company knows how much i’m making they lowballed me. Any tips on how to navigate the salary negotiation and can u share ur salary ?

like

I’ve been given a verbal offer for a Marketing Associate position at a major bank. Comp is $110k base with an annual bonus. What is an appropriate counter?

like

Has anyone had an offer rescinded due to lay offs/hiring freeze?

like

Dear Fish, I'm ready for a new challenge. Looking for a referral to a T2 strategy firm. I can provide more details about myself over chat. Thank you!!

like

Looking for an entry level remote tech position. Honestly not picky, current TC is 111k anything close to that would be appreciated.

Fish that have given 2 weeks notice in a sales role: when you gave your notice did you stay on for the full time, did you get walked with pay or walked without pay?

like

“Strategist” seems like a rare title to see when you go in house. Are there similar roles with different titles - I could be wrong, but I don’t think it’s an agency exclusive role.

I’m a 25F and just took up a Manager position in a consulting firm. I have 6 people reporting into me- all my age or older. I’m having trouble making the team take me seriously as a boss bcz of age

like

My group desperately needs a good VP. Seems like the hardest position to hire. Unless they have significant deal exp at an EB / BB, won’t be better than current associates. Need to poach but (1/2)

like

Hi Fishes,

I am currently working as an Analyst in HCL Technologies BSERV which is considered as a BPO. I received a promotion to a new job post Sr. Associate-WPC. Is this new position also a part of BPO or does it come under IT or Technical Department? Also currently there is no hike being provided even though the band has changed from 0.3 to 1.1, can I expect a hike once the yearly cycle is completed?

like

I have landed an executive assistant position right after graduation. I have been here for a year and am looking to consider my options. I was also wondering if my 3-year diploma in financial planning can be considered experience from an employer POV? Moreover, how much did your first landed job after graduation pay? TIA

like

So here is my dilemma:
- based in the UK
- opportunity for lateral internal move (culture&engagement) or stay where I am (reward). I am mid level IC struggling to progress due to flat structure so considering lateral move then hopefully up from there.
- 2 primary aged children, currently have flexibility in current/new role too
- Husband just got accepted on a international rotation which means I will be single parent for the short term.

What to do? Go with the unknown or coast comfortably?

like

Hi everyone! Health tech consultant with 2.5+ years of experience … Looking to connect with any one who’s company is hiring implementation or strategic consultants in this field… ready to leave current company after not feeling heard and/or valued for months now. Looking to increase salary and *hopefully* find unlimited PTO wherever I go

like

Wondering what other Business Analysts make? And what should I be making, I have been in this role for 1 year now

like

More Posts

After 6 months of Couch Potato life, this is all a 25 years old in his prime could give while listening to 'I feel like a Monster' at full volume.

I guess, life is a meme now🥴

Post Photo
likefunnyuplifting

Lume shot as I walked into a parking garage

Post Photo
like

How is Xoriant pune for automation testers? Also how is job security in Xoriant as one of my knower is on bench since 3 months since joining. He is worried. Guys Please suggest. PLEASE ANSWER IT'S URGENT

like

Completed AWS Solution architect professional certification. Have total experience of 14 yrs , 6 yrs in AWS. How much can I expect from a switch. Currently getting 16 lacs.

like

What ℅ standard hike Infosys HR offer to now days. Please advise.

I going to my first in person conference since the pandemic. It’s Thursday and Friday. I was thinking about business casual on Thursday (light colored pants and black blazer). Would jeans be okay for Friday? I know as a law student I always looked super formal at any conference but would it still be needed as a practicing attorney?

like

I’m a current biglaw associate thinking of lateraling to Quinn Emanuel. Looking for a more dynamic and trial-focused litigation practice, but I’m a little put off by how poorly Quinn seems to invest in support (tech, paralegals, etc) and generally seems to nickel and dime its associates. Curious how these issues feel for Quinn associates on a day to day basis.

like

Has anyone been asked to look into creative automation platforms? If so, any success with finding a good solution you would recommend?

If you lateraled from mid law to big law, what did you wish you knew beforehand? Would you go back? What are some positives ($$ aside!)?

like

I just recently promoted to HR assistant manager. I have my PHR and working towards my SPHR. I am the lowest paid employee in the depth. We have a senior specialist and a general specialist both make more than I do. They have been employed longer with the company. What is your advice on this issue?

like

Hi, ladies. How long has it taken you to find a new job?

I’m currently on the hunt for a new job and I’m feeling really utterly defeated. Over the past year I’ve probably applied to at least 100 jobs and I’ve been on 8 different interviews all with no offer. I’m not sure if I’m doing anything wrong or if there is more being done behind the scenes that have nothing to do with me. Either way, I’m getting frustrated and my productivity in my current position is slacking as a result.

like

Hi All,
I have gone through hcl interview, my profile has been created in hcl ionboard portal there i can see hcl selection statusvis complete but I have not get any confirmation in mail.
In portal it's showing HR assessment is pending I am curious about my selection, I have tried to connect with HR but she didn't respond, if anyone have any idea please comment.

Post Photo
like

How long should I expect to be in each level? Currently an AE, was an AAE at my current company for about a 1.5 years. Feels like i’ll like be in this role for up to 2 years since there is no SAE.

Genuinely interested in understanding the timeline for account specific career trajectory. I’ve seen some ppl be an AS for 3 years before becoming an AD. Totally aware that timings vary from person to person, but want to better understanding timing since im a serial planner lol

like

Im a Surgical Coordinator with MA experience getting paid about 44k a year,currently living in NYC and looking to move to CT in October. Anyone know the average for surgical coordinators in CT?

like

What kind of shoes do you guys rock at work?

like

Experienced candidate.I have done with interview.Got selection mail and submitted documents.How much time @techmahindra will take to release offer. Any chance do they drop/ignore or change decisions. Tech Mahindra

Looking for a career change, which career path has a higher salary?
Computer science or computer engineering?

like

YOE - 3.8

CTC offered - 16.7 LPA

Fixed - 14.5 LPA

Location - Bangalore

Company - Deloitte India

Please advise whether the package offered is okay or not. Do i need to look for another offer.

like

According to recent News 100% work from home allowed for sez units till December 31st 2023, does that mean legato allow work from home throughout 2023?

like

What's a ctc offerd to a deputy manager in axis bank.?

Additional Posts in Excel Genius

Need some help. Is there a fax function (Filter) so that if I want my subtotals to show a number but nothing below it to report. One expansion of a row the subtotals show but no numbers below it.

like

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

Post Photo
like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

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

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

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

Best pdf to excel converter?

like

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

like

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

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

like

What are the most typical models you all build

likehelpful

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

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Anyone know if / how to have the CapIQ and SNL (MI) excel plugins running at the same time? I always run into issues with one of them not functioning when they’re both enabled

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

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

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

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

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