| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find cells with linked content
When I open a spreadsheet, it says it contains links, but I don't think it
should. Is there a way to determine which cell(s) contain the links. Thanks. Diana |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I find cells with linked content
Well, it's not exactly an elegant solution, but try doing a Find for .xls.
In the Find dialog box, type .xls in the Find what field, then click Find All. This will present you with a list of all the cells containing the Excel file extension. Hope that helps. -- ERR229 "Cowtoon" wrote: When I open a spreadsheet, it says it contains links, but I don't think it should. Is there a way to determine which cell(s) contain the links. Thanks. Diana |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I find cells with linked content
When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm Cowtoon wrote: When I open a spreadsheet, it says it contains links, but I don't think it should. Is there a way to determine which cell(s) contain the links. Thanks. Diana -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I find cells with linked content
Well, that's interesting. I wouldn't have thought of that. However, on
doing such a search, it doesn't find any .xls results. Boooooooooooo. "ERR229" wrote: Well, it's not exactly an elegant solution, but try doing a Find for .xls. In the Find dialog box, type .xls in the Find what field, then click Find All. This will present you with a list of all the cells containing the Excel file extension. Hope that helps. -- ERR229 "Cowtoon" wrote: When I open a spreadsheet, it says it contains links, but I don't think it should. Is there a way to determine which cell(s) contain the links. Thanks. Diana |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I find cells with linked content
I'll have to give that a peek.
By the way, if it doesn't find any links ... any thoughts on what I should do. I have several charts linked to this excel file, from Powerpoint and Powerpoint just about goes into melt down, trying to update the links from this and two other files that are reporting that they have links. It's a little worrisome, to say the least. Diana "Dave Peterson" wrote: When I can't find links, I'll use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Cowtoon wrote: When I open a spreadsheet, it says it contains links, but I don't think it should. Is there a way to determine which cell(s) contain the links. Thanks. Diana -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I find cells with linked content
I don't have any guesses if it fails. But don't get too far ahead of yourself.
Bill's program looks in spots that I wouldn't have even guessed existed! Cowtoon wrote: I'll have to give that a peek. By the way, if it doesn't find any links ... any thoughts on what I should do. I have several charts linked to this excel file, from Powerpoint and Powerpoint just about goes into melt down, trying to update the links from this and two other files that are reporting that they have links. It's a little worrisome, to say the least. Diana "Dave Peterson" wrote: When I can't find links, I'll use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Cowtoon wrote: When I open a spreadsheet, it says it contains links, but I don't think it should. Is there a way to determine which cell(s) contain the links. Thanks. Diana -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| How do I sort linked cells ? | Excel Discussion (Misc queries) | |||
| Locking linked cells | Excel Worksheet Functions | |||
| how do i find cells that repeat the same content? | Excel Worksheet Functions | |||
| Linked cells | Excel Discussion (Misc queries) | |||
Linear Mode
