F
Feejo
Verify that your formulas contain a valid path, workkbook, range name, and
cell reference.
How can I search them.
cell reference.
How can I search them.
C
CLR
From Chip Pearson's site.........
FindLink by Bill Manville
This add-in is the perfect tool to help you track down links in your
workbooks. It searches out links in formulas, defined names, and controls.
Download from Stephen Bullen's site.
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink.zip
Vaya con Dios,
Chuck, CABGx
FindLink by Bill Manville
This add-in is the perfect tool to help you track down links in your
workbooks. It searches out links in formulas, defined names, and controls.
Download from Stephen Bullen's site.
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink.zip
Vaya con Dios,
Chuck, CABGx
D
dave m
Hello there,
If you go to Edit---Links in your workbook, you will see the path of each
external link.
You can then check the links and it will tell you of the invalid link.
Then do a search for the link text (Look in Formulas).
If you are only missing links to other cells in the workbook, your sheet
names may be changed. The edit links will also show you this.
Finally if you want to search manually or see the formulas while you do a
search from Edit Search, hit CONTROL AND ~ together(Next to the 1 key) this
will expand cells to show background formulas Same keys restore your sheet.
If you go to Edit---Links in your workbook, you will see the path of each
external link.
You can then check the links and it will tell you of the invalid link.
Then do a search for the link text (Look in Formulas).
If you are only missing links to other cells in the workbook, your sheet
names may be changed. The edit links will also show you this.
Finally if you want to search manually or see the formulas while you do a
search from Edit Search, hit CONTROL AND ~ together(Next to the 1 key) this
will expand cells to show background formulas Same keys restore your sheet.
F
Feejo
I click on it and nothing happen 
CLR said:
F
Feejo
I have no Edit menu in my excel 2007. I found Data, connections, and there is
no connections here.
When I press control and ~, it give me that original message and dose not
bring me to the cell that give me the error.
no connections here.
When I press control and ~, it give me that original message and dose not
bring me to the cell that give me the error.
F
Feejo
I am still stuck with that problem, I disable error, but it still showing. Do
I have to ignore all the error manualy.
I have to ignore all the error manualy.