| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Don't update excel links
In Excel 2000 when I open my workbook I don't update my Links and it shows me
the value.In Excel 2003 when I don't update my link it just shows me a error instead of the value. What can I do so that it shows me the value and not the error? |
|
#2
|
|||
|
|||
|
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 JacoH wrote: In Excel 2000 when I open my workbook I don't update my Links and it shows me the value.In Excel 2003 when I don't update my link it just shows me a error instead of the value. What can I do so that it shows me the value and not the error? -- Dave Peterson |
|
#3
|
|||
|
|||
|
Thank you.
I have try it but still have the same errors. "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 JacoH wrote: In Excel 2000 when I open my workbook I don't update my Links and it shows me the value.In Excel 2003 when I don't update my link it just shows me a error instead of the value. What can I do so that it shows me the value and not the error? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to continuously update time in Excel? | Excel Worksheet Functions | |||
| How do you set up a data excel sheet that links to a presentation. | Excel Worksheet Functions | |||
| Problems opening Excel files using DFS links | Excel Discussion (Misc queries) | |||
| auto update an open excel sheet over network, with mutiple users | Excel Worksheet Functions | |||
| Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions | |||
Linear Mode
