Under the "Edit Links" option, is there a way to delete the link listed under "Source" altogether? Not just break it but deleting that souce.

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

If the link isn’t referenced anywhere else in the workbook, it will be removed when you click delete. If it doesn’t disappear when clicking break/remove you have to find where the link is referenced and remove it then the link will disappear from your link list. Could be in formulas, charts, data validation, pivots etc. you can try searching “.xlsx” as a first step but if nothing returns will have to dig into the others this post may be helpful, esp KPMG comment https://joinfishbowl.com/post_kauiy

Related Posts

Hi all, anyone gave the codility test for microsoft interview? Please let me know what all things will be there in test? I am working as a tester - automation tester. Does this test will be more of a testing related or coding related? Microsoft

Hey fishes looking for opportunities as fresher
For better and decent package should anyone refer me 😬
I already have ITC Infotech
And Infosys offer but they are not paying upto the mark

like

Hi guys! Wanted to know if their is any difference in terms of work (or other factors) in Accenture Mumbai and Accenture Bangalore

like

Hello. I currently work at Cigna (specifically express scripts PBM). I am looking to move to a similar company working in operations/ product management roles. Does anyone have open positions or suggests on which companies to apply to?

like

I am looking for refferal in KPMG. Can anyone help?

like

I want to get a gift for my best friend who has been helping out, like planning the bachelorette trip, and will be the photographer for my small ceremony coming up. I’m thinking something in the $200 to $300 range, any suggestion?

like

Does the RSM Pittsburgh office have a real estate tax group or do they provide services to real estate tax clients?

like

Why is it some companies make you reapply to a role when you’re towards the end of the interview process?

Heads up, start reserving Valentine’s Day restaurants now… make your life easier a few months from now

likesmartfunny

I'm currently working as business analyst(band 4a) in Genpact. Have seen people in the company moving abroad. Will I be eligible to move abroad after spending an year or two? Or how are things in Genpact with regards to onsite opportunities?

Genpact

like

Does Salesforce trailhead superbadges helps answering scenario based questions ?

like

Any openings for frontend developer with 7+ years of experience in React JS?

like

Imagine your work ID inspiring this level of rhapsodic praise. It’s an effing key card.

Post Photo
funnylike

Anyone able to refer to KPMG London for a grad scheme?

Happy to share CV and state my case!

like

Folks, can we please share some good resources to study for Saas revenue models please? Thank you!

like

The power oils out here in my small Midwest city. Thank God nothing is due today!

like

How easy is it to change from tax to a diff field like audit or consulting? I joined tax after college but dont feel like it and I was wondering how easy is it to change a field within an organization? I am referring to a midsize firm

like

Join me next week as I interview Astin Hayes, Founder of the app TipOff! -Alicia

Post Photo
like

Can’t get my direct supervisor (only supervisor for 1.5 mo) to write rec because of lack of time + stigma. My former supervisor (1.5 yrs) and a project manager will be doing my recs. YOE 3.5
I’ve seen many “do I explain in optional?” jokes but does this count as an extenuating circumstance to write about? Do I write a lot of background or an direct explanation?

like

Hi everyone I am new here, need help unlocking my DM! 😅thanks!

likehelpful

Additional Posts in Excel Genius

Hi! I’ve got a number thats 6 digits and I’d like to make this 4. However, everytime I do my beginning and ending zeros disappear. Any suggestions? Or how do I shorten to 4 and keep zeros

like

I have been given a csv file and one of the columns has multiple properties. I want to split each of the properties into their own column. However every row doesn’t always have them in the same order and may have slightly different properties. Is there a way to sort this efficiently?- picture for reference, columns v onwards is how I have split with text to columns currently. Any help is greatly appreciated

Post Photo
like

Anyone know how to capture reference text (I.e. some reference of a particular word in a given cell with multiple words) within a Median(if()) formula? Usually I use the funky “*”&xyz&”*”, where xyz is the word I’m looking for, but isn’t working in this formula I have down:

=IFERROR(MEDIAN(IF(Data!$AR:$AR>0,IF(Data!$Y:$Y>0,IF(Data!$M:$AM="*"&D$345&"*",Data!$BR:$BR)))),"")

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

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

like

Can someone help me with recoding surgery question into binary variables? I’d so appreciate your help! TIA

like

Looking for a shortcut key that is the equivalent of PowePoint's Ctrl + Shift + Up/Down arrow.

Essentially a way to switch row positions w/o replacing or inserting cells...

like

Does anyone know of a good excel training online (pivot tables…filters…) ? (Preferably free)

like

Dear auditors, please explain how you pick samples for substantative testing.

like

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

like

Best way to pick up LBO modeling? Recommended resources, tips, tricks are appreciated

like

Thoughts on learning VBA? Is it useful in consulting? Many people argue Python is better to learn overall?

like

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

like

Is there a text to rows (instead of text to columns) trick?

like

Can anyone recommend good learning resources for excel? I’ve used it for years and am familiar with all the vlookups & index matches but would like to grow my skills beyond that... TIA

like

Right click menu. If you have a Logitech keyboard with no key to access the right click menu, press FN and F10 to pop open the menu. Very handy when you are trying to lose the mouse.

like

Does anybody know how to create a VBA code to automatically extract all the active data in a sheet on a different workbook without opening and manually copying to a different workbook? Ps also to create a reference cell to be able to change the file name and run macro so that it can use the reference cell to find the file and copy..

like

How do you create a lagged time series in excel? Lag of order 1 and 2

like

Is there a way to wrap your header text within access database?

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