Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find, replace, update links
I am trying to populate a column with data from a linked file. I copy over
the formula from a column and paste it in the new column. I then click on edit, links, change source and the data in the column changes. When I look at the formula in the new column, the file path is the one that I copied over and not the one from which the data is coming from. I try and do a find/replace for the entire column all at once and I'm prompted to do it row by row with a pop up box called "Update Values: (Path of source file)". I do hit the "replace all" tab and I'm still prompted to do it row by row. Ugh. This sounds like two different problems and I appreciate the responses I've gotten. But, I still need help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
not allow update for workbook w/ Links | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
Edit Links: make update manual | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) |