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
|
|||
|
|||
Links not working in Excel 2007
I now have Excel 2007--formerly I used 2003. I have a workbook that is
linked to many other workbooks. In 2003, when I opened the workbook it would ask if I wanted to update the links. When I checked Yes, it would go out and get the information and update each link. Now when I open the workbook, it doesn't ask if I want to update the links and it doesn't update them unless I open each workbook. Do I need to change a setting? CarolAn |
#2
|
|||
|
|||
Links not working in Excel 2007
Try...
Office button (upper left corner) Excel Options Advanced scroll down to the General section make sure that "Ask to update automatic links" is checked Also, in the "When calculating this workbook:" section just above the General section, you may want to check "Update links to other documents". Hope this helps, Hutch "Carolan" wrote: I now have Excel 2007--formerly I used 2003. I have a workbook that is linked to many other workbooks. In 2003, when I opened the workbook it would ask if I wanted to update the links. When I checked Yes, it would go out and get the information and update each link. Now when I open the workbook, it doesn't ask if I want to update the links and it doesn't update them unless I open each workbook. Do I need to change a setting? CarolAn |
#3
|
|||
|
|||
Links not working in Excel 2007
Both are checked but it still doesn't ask to update automatic links. Very
frustrating. I have to open 54 pages in order for the links to work on the main workbook. Any other ideas? CarolAn "Tom Hutchins" wrote: Try... Office button (upper left corner) Excel Options Advanced scroll down to the General section make sure that "Ask to update automatic links" is checked Also, in the "When calculating this workbook:" section just above the General section, you may want to check "Update links to other documents". Hope this helps, Hutch "Carolan" wrote: I now have Excel 2007--formerly I used 2003. I have a workbook that is linked to many other workbooks. In 2003, when I opened the workbook it would ask if I wanted to update the links. When I checked Yes, it would go out and get the information and update each link. Now when I open the workbook, it doesn't ask if I want to update the links and it doesn't update them unless I open each workbook. Do I need to change a setting? CarolAn |
Thread Tools | |
Display Modes | |
|
|