Removing phantom external links in Excel
cedd
I have an excel spreadsheet with some an external link in that I can't get rid of.
I have read up on the internet quite a lot and Microsoft recommend the following:
- For references in Cells: Using search and replace for [*] to find all references in worksheet cells.
- For references in names: Opening up the name manager and making sure there are no external references there.
- For references in Objects (this is really painful): Select each object individually and look in the formula bar.
- For references in Charts (also painful): Check the formula bar the title and data series for every chart.
This still leaves me with a phantom external reference that I can't find, so I try some more things
- The "Data - Edit Links" feature in Excel followed by clicking on "Break link" (nothing happens)
- Used a "FindLink" plugin (didn't work for me, but was friendly to use)
- Used Microsoft's DeleteLinks plug in (also didn't work and isn't friendly to use)
cedd
In the end I tracked this down to the conditional formatting rules.
Clicking on "Home - Conditional Formatting - Manage Rules" brings up the following dialog, which is relatively easy to look through and replace the external references.
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
에서 수정
관련 기사
Related 관련 기사
- 1
How to make Excel use relative paths in external workbook links
- 2
Removing Ubuntu 12.04 from external harddrive
- 3
Open all external links in new window
- 4
Open PDF links in external application on Chrome
- 5
Can't format external HDD after removing it from computer
- 6
How to delete external images after breaking links to them using VBA?
- 7
Why can't Excel update some of the links in my workbook
- 8
Cassandra Phantom tutorial : Are there any basic tutorials for using Phantom?
- 9
docker-compose를 공통 서비스에 연결하기 위해 external_links를 어떻게 사용합니까?
- 10
Phantom.js .NET 인증
- 11
Phantom JS + Angular JS - Parse Error
- 12
Cassandra가 포함 된 Phantom 1.25.4
- 13
Removing a directory
- 14
사라지지 않는 Phantom AWN Dock
- 15
phantom.js에서 경고 창 확인
- 16
How do I kill zombie/phantom scheduler jobs in laravel forge?
- 17
Geforce GTX-960 phantom prevents PC from boot
- 18
Playframework (Scala) 및 Cassandra를위한 Phantom 대 Quill
- 19
npm 설치 phantom.js 실패
- 20
Scala Phantom Cassandra 조건부 삽입?
- 21
Crack when removing earphones
- 22
Removing TeX Live
- 23
Removing Text From A TextBox
- 24
Removing a custom cursor on tumblr
- 25
Removing numbers in front of Array
- 26
NumberFormatInfo not removing decimals
- 27
Removing whitespace in python
- 28
Removing spacing from string
- 29
Removing last child in list
몇 마디 만하겠습니다