How do I find cells with linked content

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
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
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unlink cells- how? 0
Trying to create a dynamic filepath within VB 3
How to create absolue path link to another workbook (Excel 2003) 1
how do i locate the cell linking to another spreadsheet 2
Find External Links 6
How do I write a formula to obtain information from another spread 1
Copying linked sheet 2
Linking problems in Excel 2007 2

Back
Top