Home |
Search |
Today's Posts |
#1
|
|||
|
|||
find and replace links in Excel 2003
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!! |
#2
|
|||
|
|||
Have you try
Edit Links in the menu bar -- Regards Ron de Bruin http://www.rondebruin.nl "MAndrews" wrote in message ... 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!! |
#3
|
|||
|
|||
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 "MAndrews" wrote: 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace data by VALUE or COMMENTS not availabel in Excel 2003 ??? | Excel Discussion (Misc queries) | |||
Find and replace data in an Excel chart object | Charts and Charting in Excel | |||
Find and replace Excel, Office pro 2003 | Excel Discussion (Misc queries) | |||
Find and replace for comments in excel 2003 | Excel Discussion (Misc queries) | |||
macro to Find Replace in Excel | Excel Discussion (Misc queries) |