[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

Procedure to update links

What are the steps to update the links in the following scenario:

I have an excel file with a bunch of cells linked to File1 in Folder1.  I now want to update the links to link it to File1 in Folder2.  The format of the files in Folder1 and Folder2 is exactly the same.
0
dbfromnewjersey
Asked:
dbfromnewjersey
  • 2
  • 2
1 Solution
 
nutschCommented:
Go to Data \ Edit links and you can change the source there.

Thomas
0
 
dbfromnewjerseyAuthor Commented:
I tried doing that and it just jams up.  That's why I had to come here to ask.
I tried the following:

Data / Edit Links / Change Source

When I click Change Source, I then navigate to the folder and file I want to link to.  It just jams up.  The new source never shows up in the Edit Links window (whether it's supposed to, I don't know) or anything. Maybe it's jamming because there a lot of links to update?  There are links in approximately 5 columns and 200 rows in one worksheet.  Maybe it just takes a long time to update?
0
 
nutschCommented:
It could take a while. Try doing it with both source files opened.
0
 
dbfromnewjerseyAuthor Commented:
OK. It worked. Thanks. This whole thing is on a network drive, so apparently the server is really, really slow. I thought I was doing something wrong because the application was non-responsive for several minutes.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now