Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Links Updates in 2003
My office recently upgraded to 2003 from 97. We experienced #REF errors in
many cells in our workbooks after the upgrade. To eliminate the #REF errors I re-established most of the links in the A) Source or Data Workbook; B) Target or Dept Workbooks; and C) Target Total Workbook. Now we have a new problem. When data is changed in Workbook A, all B Workbooks must be opened in order for Workbook C to update. In 97 we only had to update data in A, then open Workbook C. All Workbooks would update and the correct data would filter to Workbook C. It would appear that there is now some sort of hierarchy of links between Workbook A, Workbooks B, and Workbook C. Unless you open each individual Workbook, Workbook C will not update. How can we overcome this problem? It is too time consuming to open each Workbook B individually. Help? Tracy B. Feb 20/06 12:46 pm -- Tracy B. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Links Updates in 2003
xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links prompt, the existing values are kept. In xl2002+, you get those errors. Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl maybe it'll help you. Tracy B. wrote: My office recently upgraded to 2003 from 97. We experienced #REF errors in many cells in our workbooks after the upgrade. To eliminate the #REF errors I re-established most of the links in the A) Source or Data Workbook; B) Target or Dept Workbooks; and C) Target Total Workbook. Now we have a new problem. When data is changed in Workbook A, all B Workbooks must be opened in order for Workbook C to update. In 97 we only had to update data in A, then open Workbook C. All Workbooks would update and the correct data would filter to Workbook C. It would appear that there is now some sort of hierarchy of links between Workbook A, Workbooks B, and Workbook C. Unless you open each individual Workbook, Workbook C will not update. How can we overcome this problem? It is too time consuming to open each Workbook B individually. Help? Tracy B. Feb 20/06 12:46 pm -- Tracy B. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Links Updates in 2003
That message may apply only for #value errors.
Post back if it fails. In fact, post back either way. Thanks, Tracy B. wrote: My office recently upgraded to 2003 from 97. We experienced #REF errors in many cells in our workbooks after the upgrade. To eliminate the #REF errors I re-established most of the links in the A) Source or Data Workbook; B) Target or Dept Workbooks; and C) Target Total Workbook. Now we have a new problem. When data is changed in Workbook A, all B Workbooks must be opened in order for Workbook C to update. In 97 we only had to update data in A, then open Workbook C. All Workbooks would update and the correct data would filter to Workbook C. It would appear that there is now some sort of hierarchy of links between Workbook A, Workbooks B, and Workbook C. Unless you open each individual Workbook, Workbook C will not update. How can we overcome this problem? It is too time consuming to open each Workbook B individually. Help? Tracy B. Feb 20/06 12:46 pm -- Tracy B. -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Links Updates in 2003
The problem occurs when I click 'Yes'. My Total file will not update with
the most recent data until each individual file has been opened and saved. With 97 it would update without having to open each individual file. -- Tracy B. "Dave Peterson" wrote: xl2002+ likes to recalculate any workbooks that were created in previous versions. In earlier versions of excel, if you answer No to the update links prompt, the existing values are kept. In xl2002+, you get those errors. Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl maybe it'll help you. Tracy B. wrote: My office recently upgraded to 2003 from 97. We experienced #REF errors in many cells in our workbooks after the upgrade. To eliminate the #REF errors I re-established most of the links in the A) Source or Data Workbook; B) Target or Dept Workbooks; and C) Target Total Workbook. Now we have a new problem. When data is changed in Workbook A, all B Workbooks must be opened in order for Workbook C to update. In 97 we only had to update data in A, then open Workbook C. All Workbooks would update and the correct data would filter to Workbook C. It would appear that there is now some sort of hierarchy of links between Workbook A, Workbooks B, and Workbook C. Unless you open each individual Workbook, Workbook C will not update. How can we overcome this problem? It is too time consuming to open each Workbook B individually. Help? Tracy B. Feb 20/06 12:46 pm -- Tracy B. -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Links Updates in 2003
I have eliminated the problem with the error message. The new problem is
that my Total workbook will not update with the new data inputed to the source workbook until each individual target workbook has been opened. I need this workbook to open with correct data without opening each individual workbook. Any ideas? -- Tracy B. "Dave Peterson" wrote: That message may apply only for #value errors. Post back if it fails. In fact, post back either way. Thanks, Tracy B. wrote: My office recently upgraded to 2003 from 97. We experienced #REF errors in many cells in our workbooks after the upgrade. To eliminate the #REF errors I re-established most of the links in the A) Source or Data Workbook; B) Target or Dept Workbooks; and C) Target Total Workbook. Now we have a new problem. When data is changed in Workbook A, all B Workbooks must be opened in order for Workbook C to update. In 97 we only had to update data in A, then open Workbook C. All Workbooks would update and the correct data would filter to Workbook C. It would appear that there is now some sort of hierarchy of links between Workbook A, Workbooks B, and Workbook C. Unless you open each individual Workbook, Workbook C will not update. How can we overcome this problem? It is too time consuming to open each Workbook B individually. Help? Tracy B. Feb 20/06 12:46 pm -- Tracy B. -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Links Updates in 2003
I'd check to make sure those links pointed at the files you wanted.
Edit|links (maybe even update values on that dialog) Tracy B. wrote: I have eliminated the problem with the error message. The new problem is that my Total workbook will not update with the new data inputed to the source workbook until each individual target workbook has been opened. I need this workbook to open with correct data without opening each individual workbook. Any ideas? -- Tracy B. "Dave Peterson" wrote: That message may apply only for #value errors. Post back if it fails. In fact, post back either way. Thanks, Tracy B. wrote: My office recently upgraded to 2003 from 97. We experienced #REF errors in many cells in our workbooks after the upgrade. To eliminate the #REF errors I re-established most of the links in the A) Source or Data Workbook; B) Target or Dept Workbooks; and C) Target Total Workbook. Now we have a new problem. When data is changed in Workbook A, all B Workbooks must be opened in order for Workbook C to update. In 97 we only had to update data in A, then open Workbook C. All Workbooks would update and the correct data would filter to Workbook C. It would appear that there is now some sort of hierarchy of links between Workbook A, Workbooks B, and Workbook C. Unless you open each individual Workbook, Workbook C will not update. How can we overcome this problem? It is too time consuming to open each Workbook B individually. Help? Tracy B. Feb 20/06 12:46 pm -- Tracy B. -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Links Updates in 2003
Dave Peterson, I want to update my total file. I click "yes" when I open the
total file. The total file does not update with the new data unless I open all other files before opening the total file. I want the total file to automatically update with the new data without opening the other files. I could do this in our old 97 version. Any other suggestions? -- Tracy B. "Dave Peterson" wrote: That message may apply only for #value errors. Post back if it fails. In fact, post back either way. Thanks, Tracy B. wrote: My office recently upgraded to 2003 from 97. We experienced #REF errors in many cells in our workbooks after the upgrade. To eliminate the #REF errors I re-established most of the links in the A) Source or Data Workbook; B) Target or Dept Workbooks; and C) Target Total Workbook. Now we have a new problem. When data is changed in Workbook A, all B Workbooks must be opened in order for Workbook C to update. In 97 we only had to update data in A, then open Workbook C. All Workbooks would update and the correct data would filter to Workbook C. It would appear that there is now some sort of hierarchy of links between Workbook A, Workbooks B, and Workbook C. Unless you open each individual Workbook, Workbook C will not update. How can we overcome this problem? It is too time consuming to open each Workbook B individually. Help? Tracy B. Feb 20/06 12:46 pm -- Tracy B. -- Dave Peterson |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Links Updates in 2003
I've never seen excel not update the links when I chose to update the links.
You may be able to force an update by: selecting all the sheets select all the cells edit|replace what: = (equal sign) with: = (equal sign) replace all ungroup the sheets If you do this once (and save the workbook), maybe it'll wake excel up. Tracy B. wrote: Dave Peterson, I want to update my total file. I click "yes" when I open the total file. The total file does not update with the new data unless I open all other files before opening the total file. I want the total file to automatically update with the new data without opening the other files. I could do this in our old 97 version. Any other suggestions? -- Tracy B. "Dave Peterson" wrote: That message may apply only for #value errors. Post back if it fails. In fact, post back either way. Thanks, Tracy B. wrote: My office recently upgraded to 2003 from 97. We experienced #REF errors in many cells in our workbooks after the upgrade. To eliminate the #REF errors I re-established most of the links in the A) Source or Data Workbook; B) Target or Dept Workbooks; and C) Target Total Workbook. Now we have a new problem. When data is changed in Workbook A, all B Workbooks must be opened in order for Workbook C to update. In 97 we only had to update data in A, then open Workbook C. All Workbooks would update and the correct data would filter to Workbook C. It would appear that there is now some sort of hierarchy of links between Workbook A, Workbooks B, and Workbook C. Unless you open each individual Workbook, Workbook C will not update. How can we overcome this problem? It is too time consuming to open each Workbook B individually. Help? Tracy B. Feb 20/06 12:46 pm -- Tracy B. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
How do I open a Quattro Pro 7.0 file in Excel 2003 | Excel Discussion (Misc queries) | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
find and replace links in Excel 2003 | Excel Worksheet Functions | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |