LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vikesh Jain
 
Posts: n/a
Default External Link error

Dear All,

I have a big workbook which has been linked to external excel files on
the network. I have been working on the file for the past one month.
Yesterday morning when I tried opening the file, I received the
following message -

Cannot find 'F:\MyDocuments\Clients\DBR-31.12.00\SPK
Formats\[FORMSRK.XLM]FORMSRK'$A$, which has been assigned to run each
time [BS.xls]CF is opened. Continuing could cause errors. Cancel
opening [BS.xls]CF?

BS refers to the excel file name that I am working on and CF is a
worksheet in the said file.

Please note that I never linked to any file with the said name. Also in
the command Edit-links displayed no such file!!

To rectify the error, I tried the following:
1. Recheck that no macro is present in the Workbook modules including
sheets and
2. Break all the external links and convert them into values, so as to
avoid any chances of error caused due to the same.

However even now I am getting the same error. Can anyone help?

 
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
External Link - Conditional Corey Excel Discussion (Misc queries) 2 March 17th 06 12:27 AM
Excel Program Link Error? Neal Henzler Excel Discussion (Misc queries) 2 February 27th 06 05:22 PM
Link to external workbook R Ormerod Excel Discussion (Misc queries) 0 September 16th 05 10:55 AM
Find a link to an external file Tadashii Excel Discussion (Misc queries) 2 June 1st 05 10:15 AM
External link KIS Excel Worksheet Functions 1 May 28th 05 12:36 PM


All times are GMT +1. The time now is 09:54 PM.

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

About Us

"It's about Microsoft Excel"