Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Excel crashes when Editing Links to Change Source Location

I'm trying to change the source location for the links in an Excel document. Every time I change the location, Excel freezes up. I have try to change it on multiple computers and with Excel 2007 and 2010.  Capture - Change Source Location . Does anyone know what could be causing this?
0
smihelp
Asked:
smihelp
  • 2
  • 2
1 Solution
 
SiddharthRoutCommented:
Few things.

1) If you point it to a different file then does Excel Still Crash? If no, then there is something wrong with that file.

2) Did you try opening Excel in Safe mode and then changing the links?

3) Do you have latest MSOFF updates?

Sid
0
 
smihelpAuthor Commented:
Thanks for the suggestions SiddharthRout! I have the latest updates, and it still crashes in Excel Safe mode. However, linking to another file doesn't crash it.

I upgraded to Windows 7 from XP, so the location the My Documents directory changed. Windows 7 doesn't let you create a "C:\Documents and Settings\User\My Documents\" folder so I can't place them in their original locations.

However, I think the issue is being caused because both these documents are linking to each other and they both don't know where to look.  
0
 
SiddharthRoutCommented:
In that case break all links and then rebuild them?

Sid
0
 
smihelpAuthor Commented:
That will work but it's very time consuming. oh well, thanks Sid!
0

Featured Post

Technology Partners: 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