• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Edit links on large files

mr_hiboy

Member
hi,


I've got a few large files which link to various files in a Links folder. I've had to move the links folder to make life similar but am now having to edit/link and change source to the new file.


Some of which are taking 5 minutes to update, I have 24 files do to each with 7 files to relink.


Very slow, any ideas to help speed it up?


thanks
 
Hi, mr_hiboy!


What kind of link do you have? Cell reference, hyperlink?

If the first one try open all workbooks, linker and linked, and save as each linked in the new folder, that will change the references in linker. At last save linker.

Then remember deleting linked at original location.


Regards!
 
Back
Top