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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update links does not work.
Hi,
I published this thread yesterday into the Chart forum, but I think this forum is more suitable, also because I did not get any feedback from the other forum. I have a WB containing 8 charts that are linked to 4 different source WBs. Although the links are correct, when I open the WB and the update box appears, I click OK but it says that some of the links are not correct. If I go into the Edit links option then check the Status, this is OK, as to confirm that the links are correct. Now, I have one thinking on this and I'm looking for confirmation. In the source WBs, some of the the source WorkSheets are hidden, is this maybe the reason why the link cannot see them? If yes, what's the option that allows to see the hidden worksheet? August 6th - I have unhidden the worksheets, but no change, I really cannot understand why, I have 4 sources, all of them do not work, I have eliminated one by one to see if there was one particularly that was creating the problem but apparently all of them are the problem, or maybe none. Is there anything generic that I should look at? Update Remote references is checked. Thank you Alex |
#2
|
|||
|
|||
Update links does not work.
Metallo wrote:
Is there anything generic that I should look at? What happens if you click No to the update links box on opening and then go into Edit / Links and try Update Now? I click OK but it says that some of the links are not correct. What exactly is the message/dialog that appears? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to skip Update Values dialog when links change tonon-existent spreadsheets? | Ken Shaffer | Links and Linking | 3 | June 6th, 2004 12:01 PM |
Excel 2000 converts UNC links to relative - need to preserve UNC links! | Jeff Adams | Links and Linking | 3 | April 15th, 2004 05:46 PM |
Update links | Kevin | Setting up and Configuration | 0 | March 18th, 2004 04:46 PM |
Update links | Kevin | Setting up and Configuration | 0 | March 17th, 2004 06:38 PM |
update links not asking... | mark | Worksheet Functions | 2 | February 27th, 2004 01:46 PM |