Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
edit links
I have a file that is linked to a very large budget file (25 megs) that is
supposed to pull info from the various sheets. When I "change source" after having renamed the budget file, it simply hangs up with the hour glass .....any suggestions? I tried a find and replace (with the file name version), but it didn't work on a global scale -- it hung up too. It worked on an individual cell basis however. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
edit links
Try turning off calculations before changing the source. (Tools-
Options-calculation(tab)-Manual). It could be trying to recalculate your whole workbook after each cell is changed. Also, it may not be "locked up"...it might finish the process if you gave it more time...how long, of course, is a question. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit links | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
VBA to edit links | Excel Discussion (Misc queries) | |||
edit links | Excel Worksheet Functions |