A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

workbook link failures



 
 
Thread Tools Display Modes
  #1  
Old October 21st, 2008, 04:54 AM posted to microsoft.public.excel.links
curiouskiwi
external usenet poster
 
Posts: 2
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) don’t. 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 couldn’t.


  #2  
Old October 21st, 2008, 07:32 AM posted to microsoft.public.excel.links
ShaneDevenshire
external usenet poster
 
Posts: 2,232
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) don’t. 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 couldn’t.


  #3  
Old October 21st, 2008, 08:57 PM posted to microsoft.public.excel.links
curiouskiwi
external usenet poster
 
Posts: 2
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) don’t. 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 couldn’t.


  #4  
Old October 23rd, 2008, 09:32 AM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:51 PM.


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