sumproduct (link to another excel workbook)
I have a w/b that has SUMPRODUCT formulas that link to values on a worksheet tab, and I know how to link to a tab on another open workbook - is it possible to link to a closed workbook that's on our network drive ?
I have a problem when I open my excel workbook, it will prompt me my workbook has a link on other workbook, this actually come after I put some formula vlookup on some range from another workbook, then I tried to removed the formula, then I saved and reopen, but still the prompt keep coming, how can I remove this link, this link has make my macro run very slow.
I have a workbook that contains link to other workbook.
Whenever I open the workbook, it displays a message box saying
"This workbook contains link to another workbook. Do you want to remove.
How do I actually remove this. The person who gave me this workbook also
does not know how to remove it.
Not sure which cell is linking to another workbook?
How do I remove it.
When I open the workbook, I get a message in the middle of the screen that says "This workbook contains links to other data sources" then I have the option to update or not update.
So if I hit "Update" , I then get a message that says "This workbook contains one or more links that cannot be updated." When I hit the Edit Link selection, the status of them all shows OK, but the workbook isn't updating again.
I have tried opening the source workbook, but still nothing. Everything was working fine yesterday. I saved and shutdown excel, then opened it back up this morning and that's what I got. It did the same thing yesterday, but somehow I was able to get it to update.
I have copied the formats of a worksheet across to a new workbook using paste special. The new workbook now shows a link to the format source workbook.
I'm really annoyed with this but I cannot break the link. I'm using Excel 2010 ; data>edit link>break link but it just won't get rid of that link.
Anyone knows a solution or is this one of those Excel bugs that cannot be undone?
Related Applications & Scripts
Softbiz reciprocal link exchange script is very powerful tool to help you with your search engine standing by increasing your site's link popularity. Script automates the job of exaching links with your link partners.Visitors can exchange links by filling a simple form. You can approve/disapprove the link partners request.
How is this reciprocal link exchange script special?
-Multi level organization of links
-Invites your visitors to exchange link
-Link exchange is fully automatic
-100% automatic reciprocal link validator
-Tracks traffic you recieve from link partners
-Automates job of keeping track of which link -partners are still linking to you
-Very strong admin panel
This is a totally free and extremely popular link directory, which already received over 1000 approved link submissions within the past month. Our link directory consists of search engine friendly categories where you can add your website and/or scripts to. No reciprocal link or fee is required, and you will never receive any spam. So simply submit your site and you are done!
Free link extractor tool helps in extracting the url or link from a specific web page.
Use this script to check if reciporical link agreements are being honoured. Check for a given link in a remote page.(Demo + source code included)