Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links to other spreadsheets
I am receiving a workbook via email that includes links to files I cannot
access. In Excel 2003, this was not a problem when i open the workbook,,, I simply could not update the links. Now under 2007, it replaces the fields with #NAME?. I can open a blank workbook and set recalc to manual then open the intended file but then would not be able to do any manual recalc unles I value copy all the externally linked cells. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links to other spreadsheets
Hi,
Did you try checking the 'Ask to update automatic links' option? Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Compatibility link Excel 2007" <Compatibility link Excel wrote in message ... I am receiving a workbook via email that includes links to files I cannot access. In Excel 2003, this was not a problem when i open the workbook,,, I simply could not update the links. Now under 2007, it replaces the fields with #NAME?. I can open a blank workbook and set recalc to manual then open the intended file but then would not be able to do any manual recalc unles I value copy all the externally linked cells. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links to other spreadsheets
Yes; that box is checked. When I try to open the file when it is first sent
to me, I never get a chance to answer the question whether to update links... I immediately get a dialog box that says "One or more invalid names were detected in this workbook. Those invalid names have been changed to #REF." "macropod" wrote: Hi, Did you try checking the 'Ask to update automatic links' option? Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Compatibility link Excel 2007" <Compatibility link Excel wrote in message ... I am receiving a workbook via email that includes links to files I cannot access. In Excel 2003, this was not a problem when i open the workbook,,, I simply could not update the links. Now under 2007, it replaces the fields with #NAME?. I can open a blank workbook and set recalc to manual then open the intended file but then would not be able to do any manual recalc unles I value copy all the externally linked cells. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links to other spreadsheets
Hi,
That sounds more like there is a problem with the names used in the workbook, rather than with any links to/from it. Maybe it's corrupt. I'd suggest contacting the author to sort out the problem. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Compatibility link Excel 2007" . com wrote in message ... Yes; that box is checked. When I try to open the file when it is first sent to me, I never get a chance to answer the question whether to update links... I immediately get a dialog box that says "One or more invalid names were detected in this workbook. Those invalid names have been changed to #REF." "macropod" wrote: Hi, Did you try checking the 'Ask to update automatic links' option? Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Compatibility link Excel 2007" <Compatibility link Excel wrote in message ... I am receiving a workbook via email that includes links to files I cannot access. In Excel 2003, this was not a problem when i open the workbook,,, I simply could not update the links. Now under 2007, it replaces the fields with #NAME?. I can open a blank workbook and set recalc to manual then open the intended file but then would not be able to do any manual recalc unles I value copy all the externally linked cells. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links to other spreadsheets
Thank for responding. I have a number of worksheets sent (emailed) from the
same source. I can open them with no trouble in 2003 but have the issue when trying to open in 2007. I am assuming it is related to tightened security in 2007... unless the names were legal in 2003 and not in 2007. Thanks again. "macropod" wrote: Hi, That sounds more like there is a problem with the names used in the workbook, rather than with any links to/from it. Maybe it's corrupt. I'd suggest contacting the author to sort out the problem. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Compatibility link Excel 2007" . com wrote in message ... Yes; that box is checked. When I try to open the file when it is first sent to me, I never get a chance to answer the question whether to update links... I immediately get a dialog box that says "One or more invalid names were detected in this workbook. Those invalid names have been changed to #REF." "macropod" wrote: Hi, Did you try checking the 'Ask to update automatic links' option? Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Compatibility link Excel 2007" <Compatibility link Excel wrote in message ... I am receiving a workbook via email that includes links to files I cannot access. In Excel 2003, this was not a problem when i open the workbook,,, I simply could not update the links. Now under 2007, it replaces the fields with #NAME?. I can open a blank workbook and set recalc to manual then open the intended file but then would not be able to do any manual recalc unles I value copy all the externally linked cells. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links to other spreadsheets
Unfortunately, you're dealing with what I consider a significant flaw in
Excel 2007. This link explains more, but essentially, any spreadsheets created in a version prior to 2007 with links to other sheets or workbooks external to the existing workbook will be recalculated and may/will return errors. There's no way in Excel 2007 to prevent the auto-recalc, according to the article. I've had the same issue come up and there's no real "fix", just an ugly workaround. See this link for more info: http://support.microsoft.com/kb/925893 Compatibility link Excel 2007 wrote: Thank for responding. I have a number of worksheets sent (emailed) from the same source. I can open them with no trouble in 2003 but have the issue when trying to open in 2007. I am assuming it is related to tightened security in 2007... unless the names were legal in 2003 and not in 2007. Thanks again. Hi, [quoted text clipped - 18 lines] the intended file but then would not be able to do any manual recalc unles I value copy all the externally linked cells. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links to other spreadsheets
Ah, so the workbooks you're getting are in an older version? In that case, it's not just that you're using Excel 2007. Rather, this
is a long-standing practice in Excel, whereby automatic links in older workbook formats are recalculated regardless of the link update setting. This behaviour goes back to at least Excel 2000. As you've found, opening the files in the earlier version stops the update. Similarly, if your source changes over the Excel 2007 and saves the file in the new format, the problem will go away. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Compatibility link Excel 2007" . com wrote in message ... Thank for responding. I have a number of worksheets sent (emailed) from the same source. I can open them with no trouble in 2003 but have the issue when trying to open in 2007. I am assuming it is related to tightened security in 2007... unless the names were legal in 2003 and not in 2007. Thanks again. "macropod" wrote: Hi, That sounds more like there is a problem with the names used in the workbook, rather than with any links to/from it. Maybe it's corrupt. I'd suggest contacting the author to sort out the problem. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Compatibility link Excel 2007" . com wrote in message ... Yes; that box is checked. When I try to open the file when it is first sent to me, I never get a chance to answer the question whether to update links... I immediately get a dialog box that says "One or more invalid names were detected in this workbook. Those invalid names have been changed to #REF." "macropod" wrote: Hi, Did you try checking the 'Ask to update automatic links' option? Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Compatibility link Excel 2007" <Compatibility link Excel wrote in message ... I am receiving a workbook via email that includes links to files I cannot access. In Excel 2003, this was not a problem when i open the workbook,,, I simply could not update the links. Now under 2007, it replaces the fields with #NAME?. I can open a blank workbook and set recalc to manual then open the intended file but then would not be able to do any manual recalc unles I value copy all the externally linked cells. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links to other spreadsheets
pistolpete66, Thank you for the explanation. It was right on and will keep
me from searching for a solution other than the workarounds in the link. I have not checked this sight since you answered in mid-Nov. Thanks again. "pistolpete66" wrote: Unfortunately, you're dealing with what I consider a significant flaw in Excel 2007. This link explains more, but essentially, any spreadsheets created in a version prior to 2007 with links to other sheets or workbooks external to the existing workbook will be recalculated and may/will return errors. There's no way in Excel 2007 to prevent the auto-recalc, according to the article. I've had the same issue come up and there's no real "fix", just an ugly workaround. See this link for more info: http://support.microsoft.com/kb/925893 Compatibility link Excel 2007 wrote: Thank for responding. I have a number of worksheets sent (emailed) from the same source. I can open them with no trouble in 2003 but have the issue when trying to open in 2007. I am assuming it is related to tightened security in 2007... unless the names were legal in 2003 and not in 2007. Thanks again. Hi, [quoted text clipped - 18 lines] the intended file but then would not be able to do any manual recalc unles I value copy all the externally linked cells. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links to other spreadsheets
Thanks macropod... I didn't mention that I was opening files created from an
earlier version - obviously, that was significant. Appreciate your help. "macropod" wrote: Ah, so the workbooks you're getting are in an older version? In that case, it's not just that you're using Excel 2007. Rather, this is a long-standing practice in Excel, whereby automatic links in older workbook formats are recalculated regardless of the link update setting. This behaviour goes back to at least Excel 2000. As you've found, opening the files in the earlier version stops the update. Similarly, if your source changes over the Excel 2007 and saves the file in the new format, the problem will go away. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Compatibility link Excel 2007" . com wrote in message ... Thank for responding. I have a number of worksheets sent (emailed) from the same source. I can open them with no trouble in 2003 but have the issue when trying to open in 2007. I am assuming it is related to tightened security in 2007... unless the names were legal in 2003 and not in 2007. Thanks again. "macropod" wrote: Hi, That sounds more like there is a problem with the names used in the workbook, rather than with any links to/from it. Maybe it's corrupt. I'd suggest contacting the author to sort out the problem. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Compatibility link Excel 2007" . com wrote in message ... Yes; that box is checked. When I try to open the file when it is first sent to me, I never get a chance to answer the question whether to update links... I immediately get a dialog box that says "One or more invalid names were detected in this workbook. Those invalid names have been changed to #REF." "macropod" wrote: Hi, Did you try checking the 'Ask to update automatic links' option? Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Compatibility link Excel 2007" <Compatibility link Excel wrote in message ... I am receiving a workbook via email that includes links to files I cannot access. In Excel 2003, this was not a problem when i open the workbook,,, I simply could not update the links. Now under 2007, it replaces the fields with #NAME?. I can open a blank workbook and set recalc to manual then open the intended file but then would not be able to do any manual recalc unles I value copy all the externally linked cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update linked spreadsheets w/o recreating links | Excel Worksheet Functions | |||
Links to Multiple Spreadsheets | Excel Worksheet Functions | |||
Change links between 2 spreadsheets | Excel Discussion (Misc queries) | |||
Deleting links to other spreadsheets | Excel Worksheet Functions | |||
Spreadsheets Links | Excel Worksheet Functions |