Solved

Excel crashes when Editing Links to Change Source Location

Posted on 2011-03-03
4
1,728 Views
Last Modified: 2012-05-11
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
Comment
Question by:smihelp
  • 2
  • 2
4 Comments
 
LVL 30

Expert Comment

by:SiddharthRout
Comment Utility
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
 

Author Comment

by:smihelp
Comment Utility
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
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 500 total points
Comment Utility
In that case break all links and then rebuild them?

Sid
0
 

Author Comment

by:smihelp
Comment Utility
That will work but it's very time consuming. oh well, thanks Sid!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now