Комментарии:
Aw ThAnk u So much i had stubborn ones the Name manager trick i didnt know!
ОтветитьSir edit link does not work (disable)
Please solve my problem 😥😥
Does this work for cell referencing in accounts when working with multiple excel sheets?
ОтветитьVery helpful! solve my problem in 5 sec! Thank you!
ОтветитьName manager approach saved my life, thank so much!!!
ОтветитьThanks a billion trillion and everything! Thank God clicked your link.. The problem finally solved!
ОтветитьGoing to Formulas and then Name Manager solved my issues. And this was something Ive been struggling with for probably like 6 years in my career. Thank you so much.
ОтветитьWhen I break a link as described in your first scenario, it doesn't do anything. Well, it laughs at me first, but then doesn't do anything. Nice video, though.
ОтветитьFinally, thanks for this
ОтветитьI have a very small model that inherited a couple worksheets from other files, and it became 4M for no reason, and file size won't shrink even if I delete all worksheets. I can see a link under Data but cannot break it. After viewing this video, I went into name manager and found hundreds if not thousands of names linking to external database. Deleting those results in a 40K file size. Feeling much better now and thanks for this video!
ОтветитьHelpful vid. Thank you!
ОтветитьThank you man!
ОтветитьOne thing to add to your list would be data validation (dropdowns) linked to an external sheet. Usually you wont be able to open up the dropdown when this is the case and will need to delete or relink the data validation.
ОтветитьThanks
ОтветитьAwesome! Thank you so much! I couldn't break an "unbreakable" link until I viewed this video
ОтветитьThank you, excellent video but none of those suggestions worked.
ОтветитьIf the file was created in 2016 and later file is opened is 2013, then external link will be prompted and the file will not work. Opening the file in Excel 2016 will solve the issue
Ответитьthis is a great help.. Thank you..
ОтветитьThis is a great help!
ОтветитьHello ! I see the links in "edit links" but i cant see, to break it, please help
ОтветитьAwesome! Thank you so much! I couldn't break an "unbreakable" link until I viewed this video. The links that I could not break were tied to other workbooks. Following the path to: Formulas->Name Manager, was the answer to breaking the link reference. I never knew that existed until now. Thank you, thank you, thank you!!!
ОтветитьFantastic video. I was mystified by an external link I couldn't find but thanks to your video it is now gone. It was in a named range.
Ответить