Excel 2000

J

JacobFI

How can I identify all linked cells in a document.

Is thera way to locate, highlight, list or any other means?


Thanks
 
G

Guest

There is no automatic way to find links used in a
document. But since links use brackets [ ] to enclose the
source name, you can search for it.

For example =COUNT([workbookname.xls]Sheet1!C1:C25).

HTH,
BC
 

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

Embed the same Excel multiple times 0
Indenting every other paragraph in Word at the same time? 0
Converting URLs in comments to Markdown-formatted links 2
Blank Page After Envelope-Label Wizard 5
Macro to select and delete levels of a document 2
Visio to Excel 0
Applying a weighting to results. 6
Default local file location - folder redirection slowness 0

Top