My problem is two pronged; both may be connected as they happened at the same
time.



The first is that all of the Excel shortcuts on my desktop are no longer
operable. This problem only relates to Excel. All other shortcuts are
operable. The Excel shortcuts will open only the Excel header toolbars but
not the workbook. I get the error message:-



"Windows cannot find (the particular workbook). Make sure you typed the
name correctly, and then try again. To search for a file, click the start
button, and then click Search."



If I then click €œOpen€� on the toolbar I can access the workbook. The same
applies if I access Excel through the Start button and click on a recently
opened Excel workbook. I created new shortcuts to see if that fixed the
problem; it did not.



The second problem I have is that on some Excel workbooks, I now cannot
create links to other workbooks. Creating links within the various
worksheets of a workbook is fine; it is only a problem when trying to link
different workbooks. I cannot find any difference between those workbooks
that support links and those that (now) dont. As this is something I need
to do constantly, I need to find a solution. The only thing that I can think
of that may have caused this problem is that I changed the location (and name
sometimes) of several files. That caused some links to €˜hang but I
re-assigned addresses to those that I could and broke those that I couldnt.

Hi,

Did you recently install a new version of Excel (2007)? Usually this
problem has to do with file associations, a Windows problem.
The second issue, again are you using 2007? If so look at the title bar and
see if the files that don't support the links are still xlsx files.

--
Thanks,
Shane Devenshire


"curiouskiwi" wrote:

My problem is two pronged; both may be connected as they happened at the same
time.



The first is that all of the Excel shortcuts on my desktop are no longer
operable. This problem only relates to Excel. All other shortcuts are
operable. The Excel shortcuts will open only the Excel header toolbars but
not the workbook. I get the error message:-



"Windows cannot find (the particular workbook). Make sure you typed the
name correctly, and then try again. To search for a file, click the start
button, and then click Search."



If I then click €œOpen€� on the toolbar I can access the workbook. The same
applies if I access Excel through the Start button and click on a recently
opened Excel workbook. I created new shortcuts to see if that fixed the
problem; it did not.



The second problem I have is that on some Excel workbooks, I now cannot
create links to other workbooks. Creating links within the various
worksheets of a workbook is fine; it is only a problem when trying to link
different workbooks. I cannot find any difference between those workbooks
that support links and those that (now) dont. As this is something I need
to do constantly, I need to find a solution. The only thing that I can think
of that may have caused this problem is that I changed the location (and name
sometimes) of several files. That caused some links to €˜hang but I
re-assigned addresses to those that I could and broke those that I couldnt.

No, no new versions of Excel have been installed. All my files are .xls and
always have been. The problem extends to files that have not been opened for
years and have no links to recent files. Is there any way of fixing the
problem? If I have to re-establish broken links, how can I locate those
links?

"ShaneDevenshire" wrote:

Hi,

Did you recently install a new version of Excel (2007)? Usually this
problem has to do with file associations, a Windows problem.
The second issue, again are you using 2007? If so look at the title bar and
see if the files that don't support the links are still xlsx files.

--
Thanks,
Shane Devenshire


"curiouskiwi" wrote:

My problem is two pronged; both may be connected as they happened at the same
time.



The first is that all of the Excel shortcuts on my desktop are no longer
operable. This problem only relates to Excel. All other shortcuts are
operable. The Excel shortcuts will open only the Excel header toolbars but
not the workbook. I get the error message:-



"Windows cannot find (the particular workbook). Make sure you typed the
name correctly, and then try again. To search for a file, click the start
button, and then click Search."



If I then click €œOpen€� on the toolbar I can access the workbook. The same
applies if I access Excel through the Start button and click on a recently
opened Excel workbook. I created new shortcuts to see if that fixed the
problem; it did not.



The second problem I have is that on some Excel workbooks, I now cannot
create links to other workbooks. Creating links within the various
worksheets of a workbook is fine; it is only a problem when trying to link
different workbooks. I cannot find any difference between those workbooks
that support links and those that (now) dont. As this is something I need
to do constantly, I need to find a solution. The only thing that I can think
of that may have caused this problem is that I changed the location (and name
sometimes) of several files. That caused some links to €˜hang but I
re-assigned addresses to those that I could and broke those that I couldnt.

Curiouskiwi wrote:
"Windows cannot find (the particular workbook). Make sure you typed the
name correctly, and then try again. To search for a file, click the start
button, and then click Search."


Shane is right - it will be a file associations problem.
Excel: Help Detect and Repair may fix it.
If not try
Start Run "%programfiles%\Microsoft Office\OfficeNN\Excel.exe" /Regserver

where NN is blank for Excel 2000 and earlier, 10 for 2002, 11 for 2003 and 12
for 2007.

[It always helps us to help you if you tell us your version of Excel and of
Windows]

If I have to re-establish broken links, how can I locate those
links?

Try FindLink from http://www.OALtd.co.uk/mvp

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup