excel edit links error source not found Coker Alabama

We are a computer repair company based in Tuscaloosa Alabama.  We offer onsite, and pickup services for your convenience, networking services, theater integration, installation and setup, hardware installation, and virus removal.

Address po box 692, Cottondale, AL 35453
Phone (205) 567-0951
Website Link

excel edit links error source not found Coker, Alabama

Has anyone experienced this or does anyone have some sort of explanation as to why this would be happening? If twenty people have the same problem, many of their concerns (and solutions) would be posted on a few threads. I select Update and the file refreshes and recalculates appearing to have updated all values (i.e. Next time they open the file the same problem occurs.

You can leave a response, or trackback from your own site. 13 Responses to "Excel 2007 Error: Link source notfound" Harlan Grove Says: Friday, 27th February, 2009 at 9:37 pm | Each links to 6 different data spreadsheets. There are certain .xlsm files in our system (some have macros and others don't) which generate "Error: Source not Found" in the Edit Links dialog box when the Check Status button Thanks MalR Attached Files: Screen dump Edit Link.xlsx File size: 348 KB Views: 6 MalR, Mar 1, 2015 #1 Deepak Excel Ninja Messages: 2,571 Pls share the workbook which houses the

In one put some text in one cell in the other link to that cell. Thanks, Amber Proposed as answer by Amber Me - MSFTMicrosoft employee, Editor Tuesday, February 01, 2011 7:22 PM Marked as answer by Jennifer ZhanModerator Tuesday, February 08, 2011 7:35 AM Tuesday, Source not found. You may also review this article for possible features or formulas that will not work without the source workbook being open.

Then open the wb with a link it should just find the already open source. no error messages). Anyway, a few seconds to run this macro finally solved my problem. Stay logged in Sign Up Now!

This may not be the problem you're having, but I thought I'd add this, in case anybody could use it. Call this a picky syntactic quirk, but filename extensions matter to Excel. That should just silently update. By listing these broken links in a dropdown box, you can select and treat each broken link differently.

Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. These are all generated by the "output query" macro command from MS Access. There are a lot of files like this, and because Excel doesn't prompt us that it isn't really getting the values from these certain .xlsm files we would have to search After what you said I found the problem is probably with a table on one worksheet.

One day when I get time I will have a decent shot at fixing it. Here is the FAQ for this forum. + Reply to Thread Results 1 to 4 of 4 Edit Links - "Error: Source not Found" with certain .xlsm files Thread Tools Show I have tried as you suggested but it doesn't work. To do this, however, must prevent you from taking advantage of the 2010 version fully since we are using the 2003 format.

Does anyone know whether this is truly an accepted deficiency of the 2010 version which will never be fixed? Best Regards, Sally Tang TechNet Subscriber Support in forum If you have any feedback on our support, please contact [email protected] Thursday, January 27, 2011 9:24 AM Reply | Quote So this doesn't seem to be a change in Excel's functionality as long as you save Book1 with references to as yet unsaved Book2. Thanks Nebu, Mar 2, 2015 #4 Deepak Excel Ninja Messages: 2,571 MalR said: ↑ Thanks Deepak.

Break broken links (de-link) When a link is broken, Excel will keep the formula in the affected cells, and even though this forumla can no longer calculate, Excel will keep theirs Login with LinkedIN Or Log In Locally Email or Username Password Remember Me Forgot Password?Register ENGINEERING.com Eng-Tips Forums Tek-Tips Forums Search Posts Find A Forum Thread Number Find An Expert Error http://support.microsoft.com/default.aspx?scid=kb;EN-US;260415 I hope this helps! On a handful of machines 2007 doesn't.

But if you do not have the source workbook open and its values have changed, these new values will not be what is shown. Source not found. What's more scary is that you can leave the values of the external reference (as of the last time the file was saved and both files were opened) by using the I too searched google, and didn't find a thing.

Excel 2003 can evaluate =[Book2]Sheet1!A1 because there's an open file with base filename Book2. Delete affected values: Simply delete the forumla in affected cells. Need more? Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? Source not found. 2003, sp3 is the beast.

Try using the SUM and IF together in an array formula such as: =SUM(IF('\\servername\path\[AX SD Weekly Trend.xls]Sheet1'!$G$1:$G$65536=CONCATENATE($D1,$C441,$A441),'\\servername\path\[AX SD Weekly Trend.xls]Sheet1'!$O$1:$O$65536,0)) * Don't forget to then use Ctrl+Shift+Enter to make it an I never saw this in 2003, but it could be a problem there too. Register now while it's still free! However, the source location is correct, as you can click on Open Source and it will open the correct file.

Related This entry was posted on Friday, 27th February, 2009 at 8:45 pm and is filed under enterprise, error, Excel, quality, Spreadsheet. No prompts, no ‘cannot update' warning. IF I open the data spreadsheets then update the links, all works. I can open any of these 42 spreadsheets no problem.

Have you used Edit / Links / Change Source to redirect the links, and saved the result? Select how to de-link. I have not really looked into Excel pulling data directly from Access, but if it meant effectively running a query for each piece, it would be time prohibitive. This nutures laziness and harms data integriy, because no matter how many broken links there are, the file will still appear to be functioning.

Donate & thank our ninjas Chandoo.org Excel Forums - Become Awesome in Excel Home Forums > Forums > Ask an Excel Question > Home Forums Forums Quick Links Search Forums What's From my perspective Excel is making a proper distinction between one file named Book2 and another named Book2.xls. Please log in using one of these methods to post your comment: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup Bill Reply With Quote 09-08, 11:56 PM #3 Re: Update fails.

Other forums I have been on have no such rule. It's very tedious to find and break each broken link manually. When you can narrow it to specific item, you may find a very specific bit of information or another Microsoft Knowledge Base article that will address it. Source not found.

More... Source not found. However, the values from Iowa.xlsm did NOT update and there was no error message indicating that the values didn't update.