Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Change (link) Source take hours?
Excel 2003.
I moved a spreadsheet into an archive directory. I then opened a spreadsheet that was linked to the newly moved xls. I go to Edit Links and try to Change the Source by navigating to the new location and selecting OK. The hour glass comes up and (it appears) never goes away. I've tried this several times with the same apparent hanging result. Is it possible that Excel needs a few hours to resolve the new link? Thanks - Russ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Change (link) Source take hours?
I've never seen excel take this much time, but I don't recall ever using a
workbook with a vast quantity of links to other workbooks (and I would imagine that it would be slower if the linked workbooks are on a network drive). You may want to try opening the workbooks that will become the new links to see how much better the reaction time is. xrbbaker wrote: Excel 2003. I moved a spreadsheet into an archive directory. I then opened a spreadsheet that was linked to the newly moved xls. I go to Edit Links and try to Change the Source by navigating to the new location and selecting OK. The hour glass comes up and (it appears) never goes away. I've tried this several times with the same apparent hanging result. Is it possible that Excel needs a few hours to resolve the new link? Thanks - Russ -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Change (link) Source take hours?
Thanks Dave. Not long after I posted it returned with an OK. I was just too
impatient. Both files were on network drives and one was very complex. It took about 45 minutes. Thanks! "Dave Peterson" wrote: I've never seen excel take this much time, but I don't recall ever using a workbook with a vast quantity of links to other workbooks (and I would imagine that it would be slower if the linked workbooks are on a network drive). You may want to try opening the workbooks that will become the new links to see how much better the reaction time is. xrbbaker wrote: Excel 2003. I moved a spreadsheet into an archive directory. I then opened a spreadsheet that was linked to the newly moved xls. I go to Edit Links and try to Change the Source by navigating to the new location and selecting OK. The hour glass comes up and (it appears) never goes away. I've tried this several times with the same apparent hanging result. Is it possible that Excel needs a few hours to resolve the new link? Thanks - Russ -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Change (link) Source take hours?
You may want to see what happens when you open all the files, then change links.
xrbbaker wrote: Thanks Dave. Not long after I posted it returned with an OK. I was just too impatient. Both files were on network drives and one was very complex. It took about 45 minutes. Thanks! "Dave Peterson" wrote: I've never seen excel take this much time, but I don't recall ever using a workbook with a vast quantity of links to other workbooks (and I would imagine that it would be slower if the linked workbooks are on a network drive). You may want to try opening the workbooks that will become the new links to see how much better the reaction time is. xrbbaker wrote: Excel 2003. I moved a spreadsheet into an archive directory. I then opened a spreadsheet that was linked to the newly moved xls. I go to Edit Links and try to Change the Source by navigating to the new location and selecting OK. The hour glass comes up and (it appears) never goes away. I've tried this several times with the same apparent hanging result. Is it possible that Excel needs a few hours to resolve the new link? Thanks - Russ -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to link without having source workbook open | Excel Worksheet Functions | |||
how do i edit link source in whole workbook? | Excel Discussion (Misc queries) | |||
How do i link an entire source wksheet to a dest' wksheet | Excel Worksheet Functions | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions |