Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 3
Default workbook link failures

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.


  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 2,344
Default workbook link failures

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.


  #3   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 3
Default workbook link failures

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.


  #4   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default workbook link failures

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find cell in Excel2000 workbook with link from another workbook? Mark4mmx Excel Discussion (Misc queries) 1 October 8th 08 12:55 PM
Excel-how to link source workbook to copy of destination workbook D Lynn Excel Worksheet Functions 1 May 29th 08 05:36 PM
Excel 2002 : Need patching for formula failures Mr. Low Excel Discussion (Misc queries) 1 May 20th 08 06:30 PM
How to link a NEW workbook back to a summary workbook? bsharp Excel Discussion (Misc queries) 0 March 19th 08 06:23 PM
link Access workbook to Excel workbook Toinett Excel Discussion (Misc queries) 1 January 31st 05 04:37 PM


All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"