find and replace links in Excel 2003

G

Guest

I recently upgraded from Office 2000 to 2003. In Excel 2000 I was able to do
a find/replace to change the links in formulas for the entire page. Example:
Find
[file1.xls] Replace [file2.xls] and Replace all (in FileX). The confusing
thing is that when I try that in Excel 2003, it searches for the file for
each number changed, whereas when I had the two files open it didn't search
at all, and it gives me #REF errors for a lot of my numbers, even though the
two files are organized exactly the same(the only difference is the month's
data changes) Does anyone know why it has started doing this? Any help
would be much appreciated!!
 
G

Guest

Never Mind! I answered my own question. I had also recently received a new
computer and all of my mapped drives had different numbers. When Excel tried
to find the files to pull information from this was causing problems. As
soon as I remapped my network drives to what they had been when I created the
files find/replace started working correctly again.

Thanks though for all replies!!

Michelle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and Replace 6
Linking Workbooks using file names in a range 2
Using wild card characters in Find & Replace 6
Find and Replace with formated data 1
Search and replace all hyperlinks in doc 2
First Time Macro 2
How do I past data into the Find and Replace box Excel 2003? 1
find and replace Excel 2007 13

Top